[vworld-tech] Database usage
Mike Shaver
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
> memory.
Especially if you want to scale beyond the memory capabilities of one
machine, you might find that memcached (http://www.danga.com/memcached/)
is helpful.
Mike
More information about the vworld-tech
mailing list