On 08/08/11 17:55, Gopala Krishna Gundeboyina wrote: > 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.
First of all try to compare performance not using ODBC. It will be also useful to compare client/server and embedded modes. ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
