Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    13

    Question Unanswered: Database structure

    This is a sort of database structure question that could I guess apply to any type of database...

    Say I have 4 production lines and I want to log serial numbers on the start of every line and off the end of every line.

    Is there any advantage in having a separate table for each Production Line and serial number logging point? (i.e. t_Line1Start, t_Line1End, t_Line2Start etc) or is it just the same as having one big table and having a LineNumber field and a StartEnd field?

    Is SQL Server just as happy dealing with fewer transactions to several tables as it is to many transactions to one table?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Can you be more specific? This is too broad, but I'd say if you "identify" your "production line" question someone may just hit the nail.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •