>I think it was somewhat speculative, but Andy commented a while back >that he thought it was probably because SQLite works within the SbS >process itself, so there's no interprocess communication necessary, as >there is with MySQL. > I guess operating system and the hardware it is running on would make a difference there.
>Optimizing the MySQL setup does help a lot, but in my experience the >performance increase for scanning is nowhere near what I've seen from >the change to SQLite. > I haven't done any optimisation of my instance; just used defaults to questions when installing it. >Here's a SQLite tool that isn't half bad. Thanks - will try it out. >Maybe the bigger problem now is that SbS >exclusively locks the SQLite database, so you must first unlock it >before you can connect to it. > I wonder whether having the SQLite db exclusively locked will cause similar issues with virus scanners, etc. i.e. that was a problem with MySQL, because it keeps a lock on the file. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
