| From: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
|---|---|
| To: | Per Schröder <per(at)mimer(dot)se> |
| Subject: | Re: Thread or not threads? |
| Date: | 2001-05-02 15:17:51 |
| Message-ID: | 3AF0251F.66CC66C2@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Per Schröder" wrote:
> I'm not an expert on Postgres SQL but my recommendations are (in the order
> I feel is most important):
>
> 1) Use a PreparedStatement !!!
> Don't recompile every statement!!!!!!
I did that.
>
>
> 2) Use batched update. Requires a JDBC 2 compliant driver.
> The purpose is to reduce the number of server roundtrips.
What is batched update?
Thank you!
--Raymond
| Attachment | Content-Type | Size |
|---|---|---|
| raymond.chui.vcf | text/x-vcard | 414 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fran Fabrizio | 2001-05-02 15:24:18 | Re: Stranger than fiction - EXPLAIN results |
| Previous Message | Jeff Meeks | 2001-05-02 14:58:39 | RE: Joining more than 2 tables |