On 14 Nov 2003 at 16:28, Arthur Hsu wrote: > Hello, > > I managed to download new CVS versions (by hand ...) and compile them on > Win32 platform (finally). Following are my test results: > > Time elapsed ADO.Net SQLite 2.8.6 SQLite CVS > 0 0 0 0 > 30 7419 5729 7920 > 60 14176 8013 10711 > 90 20760 9869 13147 > 120 26623 11033 14944 > 150 32862 12633 16598 > 180 38783 13044 17878 > 210 44472 13098 19609 > 240 49873 14120 20711 > > The CVS version is quite linear after the first 30 seconds. I'm still > digging the reason for the performance difference between 0-30 and 30-60. > Any ideas? > An important difference is that ADO.net writes records to a memory-cache, and at the point of updatedatebase writes the records to the database in a batch. If this is an advantage or not, that is a point of discussion. In a single-user environment this is mostly not a problem, except when the computer crashes, or electricity fails.
But the problem with this specific benchmark is that you are comparing things you should not compare. Maybe there is a possibility to write SQLite-data to a memory cache to, and after finishing collecting data, write them to the database. Kind regards Bert Verhees > -Arthur > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]