From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How do you rebind/reexecute a query without reparsing it? |
Date: | 2000-05-22 15:43:57 |
Message-ID: | 392955BD.72871B0B@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I come from an Oracle background and am used to being able to parse a
query once and then rebind and reexecute that same query multiple
times. This can have huge performance benefits for frequently used
queries within an application.
I am new to PostgreSQL, and am trying to figure out how to do the same
here. Specifically from the JDBC client interface. The JDBC interface
allows for rebinding and reexecuting, but the implementation seems to
rebuild the query every time and sends the new query string to the
server to have it reparse.
In digging a little deeper, I don't think that the Front End/Back End
protocol can support this type of functionality.
Is there anyway I can avoid the overhead of reparsing the statements
when all I want to do is rebind/reexecute the same statements over and
over again? (Again I need this from the JDBC interface)
thanks,
--Barry
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Lutzebaeck | 2000-05-22 15:56:02 | Re: performance and number of selected columns |
Previous Message | Dirk Lutzebaeck | 2000-05-22 15:25:04 | performance and number of selected columns |