Posted by Racter on 02/14/07 18:03

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?

[Back to original message]