On 30 Nov 2012, at 6:42pm, David de Regt <dav...@mylollc.com> wrote:
> Windows 7/64 SP1. Latest OSX (10.8). Well, 10.8 is the more recent design and had been worked on by speed-freaks equipped with Apple's new MacBooks which come with SSDs. But as you point out one shouldn't be ten times as fast as the other. > I have, however, discovered WAL mode today, and that gave about an 8x speed > improvement (2500ms before, ~330ms after). I'm still reading up on WAL to > see if it's fully safe through atomic transactions for power loss, but it > appears to be. The funny thing, though, is that iOS sped up by almost the > same order of magnitude under WAL mode (280ms -> ~40ms, but was running into > timer resolution issues that low). So, while this brings SQLite back into > the realm of acceptable performance under Windows for our usage (assuming I > can use WAL), which is great news for me, it's still very strange that it's > 8x slower than Apple-based... WAL mode is fine. Arguably more trustworthy than the old journaling style. I would definitely consider WAL acceptable, not only on Windows but also on OS X. The speed up for iOS is expected: WAL makes far better use of the way iDevice hardware is designed. > TRUNCATE mode alone gave an almost 50% improvement on windows too, > hilariously enough (2500ms->1300ms), and almost zero benefit on iOS > (280ms->260ms). Yep. Designing from the ground up for solid state has its advantages. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
