[ale] LAMP performance

[Pat Regan]

On Mon, 13 Sep 2010 17:03:39 -0400
Chris Fowler <cfowler at outpostsentinel.com> wrote:

> On Mon, 2010-09-13 at 16:31 -0400, Pat Regan wrote:
> > How large is the dataset?  Nothing says fast seeks like a dataset
> > than fits in RAM.  Memory is pretty cheap!  I know servers with 32
> > gig of ram are quite cheap.  If your database fits in that you're
> > golden :)
> > 
> > 
> 
> How to do reliably sync the database to disk?

You're right.  The synchronous writes can't be helped...  But if your
workload is mostly reads and your dataset fits in cache it is probably
still a huge win :)

We don't have enough information to know if this technique is useful in
this case.

Pat