| From: | Rini Dutta <rinid(at)rocketmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | multiple transactions |
| Date: | 2000-08-18 20:55:55 |
| Message-ID: | 20000818205555.13290.qmail@web2904.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I'm using the postgresql 7.0.2., the JDBC interface. I
need to optimise the database storage speeds in my
application. In order to do this I considered having
more than one connection so that I can have separate
transactions for performing a group of inserts into a
specific table - 1 transaction/connection for one
table. But this seems to take the same time or even a
little longer than having the transactions occur
sequentially, contrary to my expectation especially
considering that these are inserts into separate
tables.
Could you shed some light on this, and what I need to
do to make inserts using JDBC faster ?
Thanks,
Rini
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-08-19 03:20:52 | Re: Functions and Null Values |
| Previous Message | Stephan Szabo | 2000-08-18 19:58:09 | Re: possible constraint bug? |