On 16 Jan 2012, at 7:18am, Max Vlasov wrote: > Michael, thanks for the info, your tests confirms some advantages of ssd, > at least on some of the current platform (linux, can you confirm?). > Probably the page size is a parameter that also should be adjusted for > optimal performance. I suppose it can be different for different ssd > models, but it's just a guess.
Optimal page size is related to cache size. And the design of standard desktop computers means you have at least two levels of cache between your CPU and your hard disk surface. And your SQLite app may not be the only thing running on the computer that wants frequent disk access. So figuring out an optimal page size isn't easy. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
