Re: Using Multiple Selects

2004-12-16 Thread Brent Baisley
While 10 users per minute isn't all that much and your system will probably handle it without a problem, you should always worry about doing 12 queries for a single action. I'm not sure what your data structure is like, a single table with one column for each attribute or one record for each as

Using Multiple Selects

2004-12-15 Thread Shane McDonald
A quick question on the performance of the SELECT statement. I have a table with a set of 50 products, each product has about 10 attributes associated with it. The user will select certain aspects of a product (height, weight, colour, length etc.), and many products may display a particular att