Re: [Webware-discuss] prevent appserver choking when too much dat a to process

[Ian B. <ia...@co...>]

On Thu, 2002-09-26 at 02:28, Max Ischenko wrote:
> When requested dataset is too much, something bad is happens and can't
> figure what it is exactly. It seems like my servlet doesn't notice when
> DBMS finally finished serving SQL and it continues to wait for something
> (forever) while postmaster has returned to idle. Moreover, AppServer is
> lock as well (as I said earilier).
> 
> Not-so-lengthy requests are handled just fine.

I don't know Postgres very well, but MySQL lets you limit the size of
the response by ending your select with "limit 100" (or whatever size).

I suspect the problem is with the adapter.  The Postgres adapters in
particular seem to have caused lots of problems.  I would try doing the
same query from a simpler Python program, and seeing what happens.

  Ian