4 million Rows List Page, query took too long PHP messange
This topic is locked
4 million Rows List Page, query took too long PHP messange
1/13/2007 3:22:15 PM
PHPRunner General questions
H
hugolesme author
I have 4,1 million rows in a table, but when i access the list page, a message issues from PHP saying the query took to long. What I can do solve this problem ??? If I select the option to don't display records on the first page, in the Edit SQL Query, I resolve this? Looking forward to hear from you I remain Best regards Hugo
Up the time in the PHP config that a script can run,
Extend the time MySQL will process a request (mysql config),
Use indexing to make the SQL searches run lots faster,
distribute the data in different manners such that some of the searches aren't needed. One thing I do in large files, is break them up into annual files, so I'm only offering a limited current experience, then if they want to go back into the history, they have to select a different screen/table.
H
hugolesme author1/17/2007
1 - Ok I put 3600 seconds in the PHP Config
2 - I use PostgreSQL - How can I do?
3 - Every Column have index.
4 - The data is from peoples, I Cant break up into annual file. I selected the option: don't display records on the first page, in the Edit SQL Query, them I make a search for the field ID Nº and it worked. Thank You