[Tilesathome] Overall Status

[Dirk-Lüder Kreie]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jason Reid schrieb:
> Dave Hansen wrote:
>> The tiles are all stored in a mysql database, right?
>>
>> What's the reason for this?  Have we run up against some kind of
>> filesystem limit that makes storing them on the plain filesystem
>> infeasible?  

> No, we've moved from a system of storing and doing all lookups from the 
> database to storing them and accessing them directly from the file 
> system using a series of mod_rewrite rules, the only time that the 
> database is talked to is if the file can not be found for the most part.

And of course there is DB access on update of data, which seems to be
generating the real bottleneck currently.

each upload has to update a *lot* of db entries, as well as causing a
few thousand small files to be sorted all over the filesystem.

- --

Dirk-Lüder "Deelkar" Kreie
Bremen - 53.0952°N 8.8652°E

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGdxr0FUbODdpRVDwRAnYQAKCrFFyUziSnPFQ2FGJLWxxJrZsbOACeI4iA
+IjWVrIlqinFH2INyd2cWzA=
=ORtJ
-----END PGP SIGNATURE-----