David asked 10 years ago
Hi Abu ,
I have a problem with large database and some querys in phpgrid.
one of the query that take long time to load
SELECT s.seq_number,a.ticket_number,a.ticket_total,a.terminal,a.operateur_id,(SELECT FROM_UNIXTIME(a.date, '%Y-%m-%d %H:%i:%s')) as valdate
FROM (SELECT seq_number FROM moprop WHERE MOP IN (1)) s
INNER JOIN ticket a ON a.seq_number = s.seq_number
INNER JOIN items b ON b.seq_number = s.seq_number
WHERE b.crd IN (425,335,225) LIMIT 100 OFFSET 0
Each table is +/- 4-5 million records
query directly from phpmyadmin take 0.14 sec to load page
from phpgrid ( i remove LIMIT 100 normally replaced by $grid["rowNum"] = 100)
i take more than 2 minutes to load page.
any ideas ?
Thanks
Abu Ghufran answered 10 years ago
Hello,
I cannot generate exact setup and db here, I would need remote session to review this case.
Let me know your feasible time and working timezone.
I'll check this case remotely.
Mohammad answered 10 years ago
Request-URI Too Large
The requested URL's length exceeds the capacity limit for this server.
see how i can fix this problem because we have 52 fields and when i filter 3 or 4 dates filter same time why url length error come, where is length url variable
thanks.
