Database Dilemma... Please help.
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.
AskSasha Linux Consulting
More information about the PLUG