Posted by Tom on 02/14/07 18:17

On 14 Feb 2007 10:03:03 -0800, Racter wrote...
>
>
>So I have an application that does massive result sets, typically 3 to
>20k rows... someone starts a search, it might take 30-45 seconds
>before the database comes back, then awhile for it to actually pump
>the data across...
>
>Now while someone is doing that, they open up another window to do
>another search at the same time, or even see the main index page,
>which is data driven, and they are blocked... by the pending query.
>
>I'm assuming there is a way to get around this? I tried the
>PGSQL_CONNECT_FORCE_NEW thing, but that dosnt seem to solve the
>blocking problem at all.
>
>Ideas?
>


I think there are several pgsql.* settings in your php.ini file that might be
worth checking out. Saw some related to max number of links and persistent links
and might be able to adjust those.

Tom
--
Newsguy.com
75+ days of Binary and Text Retention!
Higher levels of article completion!
Broader coverage of newsgroups

[Back to original message]