Hi,
I am using external table interface to insert data into my own external
storage. Here I am calculating the performance of inserting records using a
test data of 100k records with both client and server on same machine. I am
following two approaches:
1) Inserting record by record individually (INSERT statement). I am using
ODBC client and insert is through prepared statement.
2) Insert records from another table, INSERT into ExternalTable1 SELECT *
from ABC.
approach#1 performance is 4 times to that of approach#2. I see this delay is
because of the SQL parsing? Are there transactions involved in case of
External tables? If so is it possible to disable them? If not are there any
suggestions to improve performance of approach#1.
*I am using Firebird v2.5 source code.
Thanks & Regards,
Gopala
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
