Re: Caching

If you write:

setUseServerPrepare(true)

for a PreparedStatement the driver will try and ask the backend to keep
a parse tree of it for repeated use by the client (if supported).

But if you can keep your stuff in a transaction and avoid using server
side prepared statements you'll get a better performance (the
optimization may not be so good done in advance as it does not have all
the info).

Regards,
Fernando

snpe wrote:
> What is server side prepared statement and how I used it in jdbc ?
>
> Thanks
> Haris Peco
> On Friday 29 August 2003 09:35 pm, Fernando Nasser wrote:
>
>>Yes, the current driver has setFetchSize() implemented.
>>
>>Note that you must be inside a transaction as a cursor is used for
>>implementing this. Alternatively you can be using a server side prepared
>>statement (you don't need to be inside a transaction in that case).
>>
>>If you are using an older driver, you can always declare a cursor yourself.
>>
>>Regards,
>>Fernando
>>
>>Lufkin, Brad wrote:> Whenever I execute a query and retrieve the results
>>with
>>
>>the sequence:
>>
>>> ResultSet resultSet = statement.executeQuery("SELECT blah blah
>>>blah...");
>>> while (resultSet.next()) {
>>> //do something with the resultSet
>>> }
>>>
>>>it looks like the query is completely carried out before any results are
>>>returned. This contrasts with the behavior of other databases (Informix
>>>comes to mind) where the query returns immediately and the results are
>>>returned as the database fetches them. Is my supposition correct, and, if
>>>so, is there any way to make postgres behave the same way as Informix?
>>>My reasons for wanting this behavior is that I'm displaying results in
>>>real time to a user through a GUI and the gradual display of results is
>>>preferable to a long pause followed by all the results at once.
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 5: Have you checked our extensive FAQ?
>>>
>>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9