very large page fails when user posts query

[rbarnett]

I have a problem with a very large php page that is 25 MB. It's purpose is to do a select query of records from a PostgreSQL database. The page successfully loads in the browser but when users try to Post or submit, the page fails often with a white screen or if they're lucky it will take 10 minutes to process. But it usually results in a white screen. There are 20,000 + items on the page so it is a big post.. We tried setting the memory_limit in the php.ini file as high as 80 MB from the default 8 MB but with no change.

Any help would be much appreciated. Thanks

[condoug]

try set_time_limit() but this function can still cause the browser to freeze if it doesnt get information for some time.

check out your own execution limit
ini_get('max_execution_time');

[condoug]

p.s. a 25mb text file is VERY large. have you been coding it for 30 years? :o)

[rbarnett]

Thanks for your quick response. The max_execution_time is 30.

Also, I was mistaken in my first post. The memory_limit is set to 8 M and the post_max_size was changed to 80 M.