ksa
Posts: 27
|
| Posted: 09/29/2004, 1:04 PM |
|
I have a search field that when submitted searches a database table which is several hundred MB in size. Needless to say it takes a little while to perform a search. The problem is that the results page comes up blank. Not as in 0 hits, but completely blank. I suspect it may be a timeout thing, but I'm afraid my expertise is pretty limited. I hope someone can provide a suggestion.
|
 |
 |
Last Hero
|
| Posted: 09/30/2004, 4:37 AM |
|
In php.ini change:
error_reporting = E_ALL
display_errors = On
display_startup_errors = On
max_execution_time = 300
|
|
|
|
ksa
Posts: 27
|
| Posted: 09/30/2004, 12:30 PM |
|
Thanks for the suggestion. I tried it, although I had to use the .htaccess file since I don't have access to php.ini. But regardless it didn't solve the problem. It's like the search doesn't ever complete. In phpmyadmin the search takes 10-15 seconds. When I create a similar search field using CodeCharge, it doesn't seem to complete at all.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/01/2004, 2:26 AM |
|
Try debugging your SQL and run it directly in the database to see where the problem might be.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
ksa
Posts: 27
|
| Posted: 10/02/2004, 7:03 AM |
|
I managed to solve it now. There must have been an error in my results page. I had two different search forms using the same results page. There must have been some conflict there, because when I changed it so each search form got their own results page, it worked like a charm. Thanks for your attention.
|
|
|
|
