On 30 Nov 2012, at 5:41pm, David de Regt <dav...@mylollc.com> wrote:
> Basic query set: > CREATE TABLE test (col1 int, col2 text); > [loop 500 times]: INSERT INTO TEST (col1,col2) VALUES (4,'test4') I read with interest the figures you produced so far, though I have no explanation. Can I ask which versions of Windows and OS X you're running ? The most recent version of OS X (10.8 == Mountain Lion) is extremely efficient when addressing SSDs. Not only does it implement TRIM but two levels of storage drivers have been rewritten to remove optimization assumptions which used to be valid with spinning drives but actually slow things down with SSDs. Although this mostly involves just removing extra code which no longer helps, this has made 10.8 extremely fast with SSDs which the OS correctly identifies as SSDs. However, some work has gone into doing the same thing with Windows 7 and Windows 8. But I know far less about low-level behaviour of Windows and don't know if the same things have been done. iOS speed on a recent iDevice (iPad 2+, iPhone 4+) should be within a close order of magnitude to Mac speeds, which is what you're finding. I see nothing unexpected in your iOS figures. The figures you supplied are ... well, your word 'ridiculous' is as good as any. Windows shouldn't be a tenth the speed of OS X. No matter how much I despise Microsoft it's really not that bad. Someone would have spotted something. I'm wondering whether Windows is correctly enforcing in-order-writing whereas the other OSen aren't. I predict that Linux times would be closer to OS X times than Windows times. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
