| Mimi Siu 2005-11-14, 3:23 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|