| From: | Mimi Siu <bbnoopys(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Postgresql Performance |
| Date: | 2005-11-14 07:06:42 |
| Message-ID: | 20051114070643.8482.qmail@web30502.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hello:
I am using Postgresql 8.0.3 with the ODBC driver
(8.01.100). My application will update a batch of
records (~3000 records) and i really need the update
to be completed in very short time. In order to
increase efficience, I have set "fsync=false".
When i simply use psql command line (i,e. "psql -q
DATABASE < update.sql") it takes around 2 sec to
finish the 3000 records update. However, if I use my
ODBC application to update the records, it nearly
takes about 6-8 sec to finish!!!!
Does anyone have any idea on how to improve the
performance of my update record application through
ODBC driver?? (Also I have set the AUTOCOMMIT as off
in my ODBC application already!)
thanks a lot!
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | noreply | 2005-11-14 08:25:38 | [ psqlodbc-Bugs-1000418 ] odbc_lib_connect() returns "Specified driver could not be loaded due to system error 182 (PostgreSQL ANSI)" |
| Previous Message | Anoop Kumar | 2005-11-14 05:10:19 | Re: Recommended ODBC version for compilation |