I just posted on this last week, some helpful stuff pro-webs.net/blog/2009/03/17/5-easy-things-to-make-zen-cart-cook/
Pay close attention to the Zen Cart list and also watch the number of products in new, special and featured. These display randomly and if you have say 300 products on special they all have to be queried.
~Melanie



