> >> (I guess it well might not on an SSD disk, but on a conventional > >> rotational disk, pager could read several pages ahead with one seek - > >> but does it?) > > > > No, the pager does not. Among other things, my feeling is that the > > locality of pages is not very strong, unless the database was just > > VACUUMed. > > Actually the SSD possibility makes it worse, not better. >
Simon, you gave an interesting explanation, but does this rule work in general? I mean there are many models, many sizes and so on. For example SanDisk SSD used in my Asus T91MT claims it has some internal writing cache, so this controller can have its own logic working independently of the software installed. Also, allowing several chips writing at the same time might have conflict with any OS' own caching mechanism. Besides I'm not sure the caching in any OS is smart enough to take this into account. For example (I'm not sure Windows is the best) but giving the fact that XP didn't have proper partition alignment for SSD and it took some time for enthusiasts to let MS know about this makes me think the cache system in Windows is still not smart enough even for much easier SSD-related tasks :) Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
