SQL Server Performance

Which option Is More Effeciant

Discussion in 'SQL Server 2005 General DBA Questions' started by luxuryspreads, May 17, 2007.

  1. luxuryspreads New Member

    Hello

    On our site we have multiple pieces for a product. each product has a type number assigned to it. Example Product A will have a piece that comes in 3 different sizes all of which are assigned a 7, it also has another piece that has 2 different sizes that are all assigned a 4

    what i need to do is find out what items numbers are available in my recordset.

    so basically i know that included on this page i have catagorie numbers 2,4,5,7,10

    Option A is create a new recordset that groups all my numbers
    IE select catagoryNumber from products where id = someid group by catagory

    or i can take the already existing recordset that has each product and catagory number and use asp to parse all the catagory numbers into groups like above

    What i would to know is which of the above options is more effeciant?

    Thank you,

    ~ moe
  2. satya Moderator

    Sounds good to me, are you getting any performance issues with this approach?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page