> -----Original Message----- > From: Zahraie Ramin-p96152 > Sent: Friday, September 03, 2004 11:18 AM > To: [EMAIL PROTECTED] > Subject: RE: [sqlite] One more question on the C API performance > > > > > > -----Original Message----- > > From: John LeSueur [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 03, 2004 11:09 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [sqlite] One more question on the C API performance > > > > > > > > >A 1000 rows of data return instantaneously. However when > > this very query is executed through the use of the C API > > using a very similar code to this: > > > > > >http://www.hwaci.com/sw/sqlite/quickstart.html > > > > > >The query takes about 19 seconds at best to complete. Does > > anyone know why there is such a discrepancy? > > > > > >Thanks very much in advance. > > > > > >Regards > > > > > What does your callback do? Is it possible that's the bottleneck? > > > > Hi John > > Thanks again for the reply. That very well may be! The call > back puts the column data in a std::map and then the std::map > in std::vector. This is so column and row data can be easily > accessed. That very well may be the bottle neck. I will try > to come up with another way of doing this. >
John Unfortunately STL is not the problem. It takes approximately ~15 seconds from the time 'sqlite_exec' is executed to the time when the first callback is received. Regards