> -----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. Thanks. RZ
