>But still, hardware is the biggest issue when it comes to any database
>performance. After that comes proper indexing and optimized queries.
I strongly disagree about the order. Proper queries and indexing are much more
important than hardware. A full join of three 1,000,000 record tables will run
much slower on the fastest hardware there is than the same query on an old 486
with 32 MB RAM if you have the right keys to eliminate the full join aspect.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
Running Blog
http://sasha.fastrunningblog.com
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/