Hi Guys,
we've recently become very busy and are getting nearly to the stage of getting 400 orders per day. We have noticed considerable latency occuring recently when looking in the admin system within zen-cart.

Key pages that take a long time to load. Category/Products, customers, orders.

We are on a dedicated server.
running Zen-Cart V1.3.8a

is there anything we can do to zencart that may help refine this?
i noticed an option under 'store-manager' called Optimize Database. I've read some things on the zen-cart forums that say this feature doesn't work correctly. Are there any updates to this that i should apply before continuing? + is there any other things within zen-cart that i could do in order to speed up the admin? likes alteration to core code that fetches the customers/orders/categories etc.

regards
Andy.