Linux: Sqlite 3.5.9, AMD x64 3800 (2ghz) dual core, 2gb RAM, 7200rpm drive.
SQL error near line 100: no such table: TEST1 SQL error near line 115: no such table: TEST1 TestNumber|Description|ROUND(EndTime- StartTime,2)|Rows|Round(Rows/(EndTime-StartTime)/1000)||'K Rows/Second' 0|performance.txt,v 1.0|1.0|0|0.0K Rows/Second 1|Trivial Inserts|24.34|10077696|414.0K Rows/Second 2|Trivial Selects|1.6|10077696|6286.0K Rows/Second 3|Trivial Updates|130.56|10077696|77.0K Rows/Second 4|Trivial Deletes|35.13|10077696|287.0K Rows/Second 5|Insert with calculations|0.0|1|2.0K Rows/Second 6|Updates with calculations and longer rows|0.0|1|2.0K Rows/Second Interesting that your hard drive is 5000rpm but yet your getting x2 performance. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users