In my case, I have client applications which connect to Firebird server using ODBC driver. Any event on the client application is inserted into a FB external table on the fly. I am exploring possibilities to speed up this process.
-Gopala On Tue, Aug 9, 2011 at 12:21 PM, Alex Peshkoff <peshk...@mail.ru> wrote: > 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 >
------------------------------------------------------------------------------ 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
