the INSERT statement above takes approx. 150 milliseconds to complete, which is very slow compared to Access/ADO, which does the same in 3 milliseconds.
As you know, average (read) disk access times are between 10~15 miliseconds, so it's impossible to Access/ADO to have commited your data to disk in that time.
Please read about the "PRAGMA SYNCHRONOUS" command [1] and you will probably find similar results then.
Regards, ~Nuno Lucas
[1] http://www.sqlite.org/lang.html#pragma_synchronous
