On Tue, 25 Jul 2006 23:13:31 +0200, you wrote: >Hi, > >we just found that when using file-based temporary storage (compile >time macro definition TEMP_STORE=1) vs. memory-based temporary >storage (TEMP_STORE=2), on Mac OS X, the performance almost doesn't >degrade at all, whereas on Windows, we're getting a huge performance >penalty when using file-based temporary storage. > >We are compiling sqlite 3.3.6 ourselves using pretty much the stock >compile time options, except for TEMP_STORE and THREAD_SAFE=1. >We also found that apparently, database performance with TEMP_STORE=1 >is especially slow when running on Windows XP (SP2). > >OS Versions where Mac OS X 10.4.4 and Windows XP (SP2). >Both machines were equipped with > 1 GB of RAM, but since we're using >file temp storage, memory usage is not really a limit here. Hard disk >performance should be about equal on both machines.
You don't mention the settings / optimisations of the filesystems, nor the amount of memory the OS allows the filesystem for caching. At least in Windows, server and desktop versions have different optimisations. In my opinion this might make a significant difference. -- ( Kees Nuyt ) c[_]
