-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brown, Daniel wrote: > Has anyone tried to replicate this bug on WindowsXP too?
There are two separate bugs here. One is that when Vista is told a file is used for random access and then there is a lot of file access, it may use a little too much memory for cache instead of applications which causes those application to be sluggish sometimes to the point of unusability. The second is that SQLite when opening a file under Windows explicitly tells Windows that the file will be used for random access even though that is not the case. Windows uses this hint to override its builtin heuristics which can cause bug #1. Bug #1 will not happen under default Windows XP configurations as XP uses 10 MB of memory for file caching no matter how much RAM you have. See "Zero" on http://www.sqlite.org/cvstrac/wiki/wiki?p=PerformanceTuningWindows Bug #2 is that SQLite is lying to the operating system and could result in performance degradation if the operating system actually pays attention to the hint. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFI0ag9mOOfHg372QQRAvCuAJ4uVYifeD7PsEVuyN2Mt1VFdqfHjwCgv3tj /P62UEnqepRAfhV2QczfBKs= =9ZV0 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users