> Here Helen advice "more doesn't mean better with page cache". What about
> with users that do need to handle a lot of data as query results (i.e.
> monthly bill generation of a service company with millions of records to
> select and insert in the same process) and most of the other users that just
> perform small transactions?
> Isn't there another solution than to replicate and use different servers?

Wich Classic, you can adjust cache size for each connection separately.

Ivan