Brian Baquiran wrote:
are you combining them in a single BEGIN/COMMIT (or ROLLBACK) transaction?
yes.
This makes a very big difference in performance.
that's true. just curios, it this also the reason why mysql lacks such functions because mysql doesnt need it in order to rev up its performance?
Also, if you're just doing bulk INSERTs, you might want to use COPY instead.
thanks for the tip! is it supported on lower odbc levels? however, our case is more than copying coz it actually fetches for valid SQL(insert/update/delete) queries logged on a remote server. then those queries will be executed on a local server that will yield the same data with the remote server. and it is conducted every _ minute(s). salamat. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
