Hi everyone, i'm redesigning my product page cause my product amount increased dramatically (45 and more underway) and some products don't need news or education links or whatever section they won't be using out of the 10 dbase driven sections available.

Now i'm using a recordset that counts the record in each table by product, if value is 0, the education.asp?productID=That particular product will not be shown.

my question:
Is it wise to integrate the count query into the main productDetail query, so that those values are in the same query as my product name, systemManager, DepartmentName, short description, generalinfo (value 0 or 1 depending on the count), education(value depending on count) and more fields coming my way.

Which is best on system resources, there's a additional query for the last news item and other stuff happening, my new template includes a recordset that grabs layout stuff like now browsing FIS Support for Oracle Account Receivable for instance with appropriate css styles and stuff. And pages load slow with multiple requests... it seems i need to adapt now that we'll be running this on one of our own servers not on the intranet servers that ban VB-script, sacrificing speed for vb-script, it better be worth it.

Tips are welcome, thanks.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services

Or is it smarter, system resource wise, to add a few fields to the product update page, storing these active values in the main product table ?

Currently i've got demand for:

- Product Brochure
- General information
- Latest development (product news)
- Product downloads
- Contacts
- FAQ
- Authorisation
- Education and Tutorials
- Developments
- Interfaces
- Live support (forum)

There's currently only 1 product that needs all these links active on their product detail page. There's a downside to using checkboxes for that, if they do need a option they didn't check, they need an administrator to activate it, with the count records method all links are allready available and just won't be shown if they don't use those features. And another downside is once you add the product it will be available on the website immediately with checked links going to pages showing, sorry there's no data entered yet for this product, crap i don't want to add another is product active yes/no check and having to instruct my administrators of yet another change they need to be aware of, it also means more work for them.

Advice is appreciated, for now i'll stick with the seperate count method.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services