By the way, I have a new MacBook Pro with a Solid State Drive which supports TRIM. Was running some unit tests which include plenty of SQLite operations. The apps in question use various recent versions of SQLite and don't use any PRAGMAs on any of them.
Fast. Fasty fast. Speed is high. INSERT, UPDATE, and DELETE all significantly faster. SELECT is a bit faster, but there's less difference. Of course, the question of what fsync() actually does is now even more of a mystery. SSDs do quite complicated things when they make changes. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
