On Fri, 26 Mar 2004 08:20:52 -0500 Walt Reed <exim@???> wrote:
> Keep in mind that MySQL has internal caching that can be enabled and
> tweaked quite a bit. If your box has ample memory, you can get pretty
> decent performance increases by giving MySQL more memory to work with.
the other thing is that connection pooling can be a major win, which is
why installing SQL Relay can make a huge difference. the very act of
connecting to an SQL database is expensive, which is why turning on
persistent connections in PHP (to name one example) can significantly
reduce load on a web/database server.
i'd urge Daniel to try improving MySQL's cache size and installing
a connection pooling package and see where it gets him before he
spend a lot of time on could-bes and should-bes.
richard
--
Richard Welty rwelty@???
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security
