I need to apologize once again. Slow deletes explained as bug in SQLite tests and flags of Perst compilation. Now they both head to head on basic ops with 2x on Perst selects (can be due to the ADO reader instantiations) http://www.nabble.com/file/p24795731/TestIndex.cs TestIndex.cs
SQLITE TEST inserting 100000 records: 4.4062500 performing 200000 index searches: 7.2500000 iteration through 200000 records: 1.1875000 deleting 100000 records: 3.9843750 PERST TEST inserting 100000 records: 4.1562500 performing 200000 index searches: 2.5156250 iteration through 200000 records: 1.7343750 deleting 100000 records: 4.3437500 SQLITE TEST inserting 1000000 records: 49.7031250 performing 2000000 index searches: 76.6718750 iteration through 2000000 records: 11.9989795 deleting 1000000 records: 46.7937535 PERST TEST inserting 1000000 records: 53.1406250 performing 2000000 index searches: 29.9375000 iteration through 2000000 records: 19.7187500 deleting 1000000 records: 53.7206640 ----- Best Regards. Max Kosenko. -- View this message in context: http://www.nabble.com/ANN%3A--SQLite-3.6.16.C--tp24764742p24795731.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users