Borox
Member
Hi,
I have a table with 5 joins:
The main table has about 350 records, the joined tables have between 100 and 700 records.
When I display the list it's very very slow ( more than 1mn!)
Of course part of these performances are due to my server ( dedicate server, 4 CPU, 8Go RAM), but the number of records in the table is not that high.
I dropped the joined table to see what happen and the performance increased, so the problem seems to be the joins.
I optimized and repaired the tables with phpMyAdmin, but it had no effect.
Even the use of the pagination is very slow ( 20s between pages)
Any idea to improve the performance?
Thanks
I have a table with 5 joins:
The main table has about 350 records, the joined tables have between 100 and 700 records.
When I display the list it's very very slow ( more than 1mn!)
Of course part of these performances are due to my server ( dedicate server, 4 CPU, 8Go RAM), but the number of records in the table is not that high.
I dropped the joined table to see what happen and the performance increased, so the problem seems to be the joins.
I optimized and repaired the tables with phpMyAdmin, but it had no effect.
Even the use of the pagination is very slow ( 20s between pages)
Any idea to improve the performance?
Thanks
Last edited: