[vworld-tech] Database usage
shaver at off.net
Tue Feb 10 13:58:23 PST 2004
Lee Faris wrote:
> Brian Hook wrote:
>>- how do others use the database?
> We have a cache layer over the DB. Almost nothing is put in the cache at
> load time. As players log in and access rooms all the associated data is
> read in to the cache. It keeps a list of the most recently used objects.
> When new objects are added and the list is full the cache will dump the
> objects at the bottom of the list. The size of the list is tweakable so you
> could set it to be nearly disk-based to have room for the whole db in
Especially if you want to scale beyond the memory capabilities of one
machine, you might find that memcached (http://www.danga.com/memcached/)
More information about the vworld-tech