SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Michigan
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Convincing friend to reconsider design

    My friend insists on creating a new database for new data depending on what `round` it is. I've been trying to convince him to save the round data to another table and just link it instead of using the name in the table name. Any suggestions on what to tell him, why this is bad, ect?

  2. #2
    SitePoint Evangelist comfixit's Avatar
    Join Date
    Dec 2004
    Location
    Pasadena
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I suggest you provide more information. As far as I can tell your friend is trying to build some sort of boxing statistics program. I dont know what you mean by rounds. Please elaborate on the overall scope of the project to put what your saying in prospective.

  3. #3
    Non-Member l0t3k's Avatar
    Join Date
    Feb 2005
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    round data????

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,338
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    yeah, not enough info to offer specific advice, however, "new database" is hardly ever necessary, nor "new tables" either

    i have seen many instances where people feel the need to split stuff off into new tables, ostensibly for the reason that "otherwise the queries take too long", and invariably it turns out that they have not understood the importance of proper indexing
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Evangelist comfixit's Avatar
    Join Date
    Dec 2004
    Location
    Pasadena
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well given that everything breaks down to binary. I would assume roughly half of the data is round.

  6. #6
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Michigan
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm sorry. I should have provided more information but was short on time. He is developing an application where matches are broken into `rounds` (basically like a two week cycle). Each round can have a number of matches between multiple teams. The application stores information about each persons stats during that match. The table structure I'm trying to get him off looks something like:

    Name of each new column, with the variables in bold:
    statsround_match_id

    with columns like so:

    person, team, time played, ect

    Example table names look like:
    stats1_1
    stats1_2
    stats1_3

    stats2_1
    stats2_2
    stats2_3

    and so on.

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,338
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    that's sad

    ask him to write the sql to show summary win percentages for all teams that played in the first two rounds
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  8. #8
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Michigan
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was also thinking querys which involve all players, like total time played, ect.

  9. #9
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Michigan
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Heh, I asked him these questions and he responded with something along the lines of "I don't know, I havn't got that far yet."


Bookmarks

Posting Permissions

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