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?
John LeSueur