I find the how you index your data is extemely import. I have a stopwatch very handy. I always use huge amounts of test data to test for speed. Using data that does not have proper indexing will cause you alot of grief.
Happy Holidays,
joe