>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.
*/

Reply via email to