3 ms·
> read/write to a DB is always slower than a filesystem I always thought it was the other way around. Databases can cache data and keep files opened (keep the
by lucb1e 15y ago
> read/write to a DB is always slower than a filesystem
I always thought it was the other way around. Databases can cache data and keep files opened (keep the file locked or something, I don't know).
Also my own benchmarks on an old laptop (MySQL versus FAT32) turned out that MySQL was actually faster, even if you still had to connect (no persistent connection). I should try this again on a decent server and use NTFS or Ext3 (see if that makes much difference), but in general I can't really see how a database can be slower--given that you use it for what a database should be used for. Of course if you read a movie from it once a day, it's not gonna cache that and the file handle is not going to help much either. Then MySQL is only an obstruction to the data which it has to read from the disk anyway. Hmm or is that what he meant here?