Hi,
IMHO, you shouldn't upgrade. Buy another machine and have your DB server run off
in the other machine. So even if your DB eats up your CPU, your LTSP isn't affected.
You could even use a P3 to run your DB server, if you have some lying around unused.
Further, I don't believe the problem is in your hardware. If you can, you should do
something about your queries that "run for about 7 minutes". What kind of queries
does that one department do? against what server? I've seen pretty heavy DB apps
(mapping/gis) running on P3 (Firebird/interbase DB) but they never seem to take that
long.
But, what do I know, am just a newbie here. (",)
Blue
*********** REPLY SEPARATOR ***********
On 7/22/2003 at 5:33 PM Winelfred G. Pasamba wrote:
>hi all,
>
>i'm using a pentium iv 1.6Ghz with 512MB or RDRAM as a database server,
>application server, smb server, dhcpd, ltsp (text), lpd server, nfs server
>(ltsp), web server, etc...
>
>the problem is the it slows down when one department does their database
>reporting. the queries run for about 7 minutes hogging the whole cpu. and
>other users (about 20) complain that the keystroke responses get long at
>times.
>
>what kind of linux server hardware setup would you recommend? looks like
>we need to upgrade in the near future.
>
>thanks.
>--
>Philippine Linux Users' Group (PLUG) Mailing List
>[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph)
>Official Website: http://plug.linux.org.ph
>Searchable Archives: http://marc.free.net.ph
>.
>To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
>.
>Are you a Linux newbie? To join the newbie list, go to
>http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
--
Philippine Linux Users' Group (PLUG) Mailing List
[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph)
Official Website: http://plug.linux.org.ph
Searchable Archives: http://marc.free.net.ph
.
To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
.
Are you a Linux newbie? To join the newbie list, go to
http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
