Database Dilemma... Please help.

Sasha Pachev sasha at asksasha.com
Fri Apr 7 10:22:28 MDT 2006


 >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




More information about the PLUG mailing list