[sldev] Cache speed experiment & results...

[Robin Cornelius]

Dale Mahalko wrote:
> 
> There are however filesystem limitations that may cause slowdowns, and
> there may be diminishing returns at some point if only the local OS is
> relied upon for huge caching storage. I would be interested to see
> what performance gain is possible by have a dedicated slave MySQL
> database running on the client PC when using a ridiculously huge cache
> size..

From what figures i have seen from random googling file system should
still be significantly quicker access than via MySQL. I started hacking
in a mysql read/write for the cache, just for the hell of it but fully
expect it to be slower than the cache and its on the big stack of things
to do.

> 
> Windows isn't good at dealing with directories containing tens of
> thousands of files. Ever tried opening a folder containing 20,000
> files? There is a delay of several seconds trying to do this in
> Windows. Also the hidden MFT and directory structures can become
> ridiculously fragmented, also leading to slowdowns.

Yes this is an issue where the DB's could achieve better performance. Or
possibly caches such as squid although how that could directly be used
with the current set up is not obvious to me.

Linux has optimisation options if you know a FS will be used for lots of
 files

Robin


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.secondlife.com/pipermail/sldev/attachments/20080604/b3cbbc54/signature-0001.pgp