Hi!

Moreover, you can add shadow to this database and you will gain speed on read, but will have the same speed as HDD on write.

Other way to keep data from in-memory database - backup it periodically :)

Tuesday, January 22, 2013, 1:11:05 PM, you wrote:

m> On linux i can mount a partition in memory (Install ubuntu/debian)

m> sudo mkdir /mnt/ram
m> sudo mount -t ramfs -o size=200G ramfs /mnt/ram
m> mount to show you the partitions mounted

m> and then move your database into the ram partition

m> http://aws.typepad.com/aws/2013/01/ec2-for-in-memory-computing-the-high-memory-cluster-eight-extra-large.html

m> That large instance could help you with the Firebird cache
m> settings also the extra SSD could do wonders

m> Inspired by the stack overflow big fat server architecture

m> http://highscalability.com/blog/2009/8/5/stack-overflow-architecture.html



m> ------------------------------------

m> Yahoo! Groups Links





--
Best regards,
Sergey mailto:serj@...