Joshua Paine wrote: > Some web hosts, like DreamHost and Mosso, provide only NFS-based > storage. I would very much like to know if it's possible to run SQLite > safely on these (Mosso, actually), so I need some way of testing if the > NFS implementation is adequate.
A quickie port of my app to MySQL only took ~30 min, so I worried about that a bit more than necessary. But I found to my surprise that for my smallish data set without much attempt at optimization either way, MySQL-over-internal-network doesn't seem to have any substantial speed advantage over SQLite-over-NFS on Mosso. SQLite may even be faster. So now that I know performance is a toss-up, it would be really nice to know if I'm safe using SQLite on NFS. Anyone have any thoughts? What kind of race conditions should I be simulating? Is it enough, do you think, to make a simple page that runs a few inserts and try to load it with N clients simultaneously a few [dozen? hundred? thousand?] times? -- Joshua Paine LetterBlock: Web applications built with joy http://letterblock.com/ 301-576-1920 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
