I'm no expert, but from what I've read: fixed is better if you can use it, and yes to the tinyint question.. :)
At 02:58 PM 6/24/2007, you wrote: >I've got the following tables: Customers and Products. I want to >create an intersection table called Customer_Products to house the >specific products that each customer gets. In this example, the >customers are grocery stores, and the products are bakery items. Not >all Customers (stores) will sell the same products, but most will share >the majority of products for their selling. > >Do I take the minimal data approach and create an exception table, >listing the products that the specific Customer does NOT carry (option >1), or do I store each valid product the customer carries (option 2)? > >So for option 1, to get the products for a given customer would be this >SQL (EXCLUSION approach): > select * from products where ipk not in (select iproductid from >customers_products where icustid = ?viCust) > >Or the sql for option 2 (INCLUSION approach): > select * from products where ipk in (select iproductid from >customers_products where icustid = ?viCust) > >I figured that if most of the time, the majority of products are >available to a customer, it'd be better to choose option 1, because it'd >be less intensive data operations. > >Your comments appreciated...tia! >--Michael > >-- >Michael J. Babcock, MCP >MB Software Solutions, LLC >http://mbsoftwaresolutions.com >http://fabmate.com >"Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
