You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
#1 2013-04-19 23:25:30
- yassinchook
- Member
- Registered: 2013-01-10
- Posts: 25
600 000 records in the glpi_users table causes slowness
in the glpi_users table i have more than 600 000 records , so the application become so slow , when i want to create new ticket or any thing in relation the table glpi_user or see the users records in Administration>Users even if i'm showing only 20 records , it may take 30 secondes or maybee more ,
any clues ?
thanks fr advance
Offline
#2 2013-04-20 09:59:36
- ddurieux
- Plugins Dev
- From: Propières, France
- Registered: 2005-06-17
- Posts: 7,521
Re: 600 000 records in the glpi_users table causes slowness
Perhaps your MySQL server not optimized.
You can use debug moed (in your settings) and after in this page you will see all SQL queries and time for each
Offline
#3 2013-04-20 10:02:53
- remi
- GLPI-DEV
- From: Champagne
- Registered: 2007-04-28
- Posts: 7,127
- Website
Re: 600 000 records in the glpi_users table causes slowness
Remove Profil and Entity columns from the default view.
This columns requires to much table and make this too long.
Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/
Offline
#4 2013-04-20 11:17:17
- yassinchook
- Member
- Registered: 2013-01-10
- Posts: 25
Re: 600 000 records in the glpi_users table causes slowness
Remove Profil and Entity columns from the default view.
This columns requires to much table and make this too long.
tnks for the answer , can you please be more specific , howa can i do that ?
Offline