[Adult SEO]

Originally Posted by Lynne

Only put stuff into memory if you are prepared to lose it. vb puts the session tables into memory but that's it.

Well, looking at the potential benefit: a forum that runs 3000x faster in practice, a comprehensive failsafe for it may be worth the effort?

I think this problem can be overcome.

And think about the benefits. Everything can just work as it does now, it will just work 3000x faster and requires some extra code for the failsafe. And most servers remain up for months easily, so it's not that the tables would need to be repopulated every day or so.

And ram isn't very expensive anymore, you could easily install 32 gig extra ram for your tables for just about $1000 dollar (high quality ram).

The benefit: a forum that can run as normally (also with the regular MySQL slave server configuration) but 3000x as fast as when using InnoDB or MyISAM tables.

--------------- Added 26 Mar 2009 at 21:50 ---------------

Intel is getting a memory like disk on the market:

Intel? X25-E Extreme SATA Solid-State Drive

Sustained sequential read: up to 250 MB/s
Sustained sequential write: up to 170 MB/s

http://www.intel.com/design/flash/na...reme/index.htm

Compared to a 15k SCSI disk with a read speed of about 80MB/s it is very good!

However, it is still nothing compared to DDR3-1600 ram speed: 12800 MB/s (about 250 times as fast as a regular SCSI disk)