Possibly the reason a large number of us are still running Win 2000 :-) It seems to be the least Windows like Windoze ever released...
When follow on support degrades to an untenable level, I'll either switch to Linux with a Windoze emulator or maybe run whatever the future ruler of the Universe (Google) tells me to :-) By then, I figure to be carrying around a holographic 42" 3-D display, surround sound cell phone anyhow. BTW, that will have the same form factor as the "Star trek Next Generation", Communicator. Fred -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Simpson Sent: Wednesday, September 17, 2008 9:54 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Vista frustrations The real frustration is that this seems to be a rather obvious bug in Vista, and definitely not SQLite's responsibility. IMO setting the flag is the "right thing to do" -- but at the same time, I don't expect any favors from Microsoft in fixing this any time soon. Meanwhile all those poor Vista people need SQLite to work well with their OS. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Binns Sent: Wednesday, September 17, 2008 1:18 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Vista frustrations -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Robert Simpson wrote: > To me this seems like an obvious bug in Vista, Actually I'd argue that it is behaving as designed. Generally filesystem code will try to detect what is going on under the hood. In particular if it looks like you are doing sequential access(*) then they will start doing read ahead, whereas read ahead is a waste for random access. By using the sequential or random flags you are explicitly telling the filesystem to ignore its heuristics and do as you say only. Since SQLite cannot tell in advance whether access is almost entirely random or almost entirely sequential, it makes far more sense to let the operating system use its builtin heuristics and optimise accordingly. (*) Sun's ZFS can even detect strided sequential access - ie reading X amount of data every Y kilobytes. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFI0L0vmOOfHg372QQRAk+7AKCEloS0d+xB+M2C/Bap38ilZZ8tVACfciC4 vMfbYMNVV9k6CNR7hpSQo6A= =AXGU -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users