[vworld-tech] Database usage

[Mike Shaver]

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