Hi David.
On Wed 2002-10-30 at 14:56:38 -0600, [EMAIL PROTECTED] wrote:
>
> I have a word search application using mysql and (perl or mod_perl).
> After all the optimization of code I now want to get a faster box.
>
[...]
> I have 2 choices:
> a. box with 1.3 GHZ with 1.5 GIG of RAM
> b. 750 MHZ with 3 GIG of RAM
>
> These 2 choices are limited by cost.
>
> What would be better for a mysql/(perl or mod_perl) application the CPU
> speed or the need for RAM.
The answer is: it depends.
It depends on a lot of underlying variables of which you provided only
a handful (e.g. the database sizes and usage patterns are missing).
Even if you had provided more information, it is always a hard guess
what will become the next bottleneck without intimate knowledge of the
application.
You should try to find out which will become your next bottleneck by
writing some tests scripts and running them against your current
hardware. While doing so, observe the system stats, e.g. with vmstat
or alike.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
