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

K
Keith 1/13/2007

You have several solutions available...

  1. Up the time in the PHP config that a script can run,
  2. Extend the time MySQL will process a request (mysql config),
  3. Use indexing to make the SQL searches run lots faster,
  4. 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 author 1/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