Creloaded Expert -- subproducts display problem

I have a creloaded oscommerce site. If all subproducts of a main product are out of stock, the entire main and subproducts should not display. I hired someone that did just that, but the queries are too slow now. I need a better method if there is one. This must be a common problem. Only EXPERTS need apply please. This is too important for a novice. I need this done ASAP, as we are getting complaints. I will PM the URL. Thank you!