Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2011
    Posts
    4

    Angry How to determine?

    Hi All Members,

    Have joined this group just now....

    Pl help in deciding what is the right approach......

    Is it better to have more tables with less records or less tables with more records?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by vknadagouda View Post
    Is it better to have more tables with less records or less tables with more records?
    the latter
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I think that the answer depends on the specific problem, so either one might be right for a given situation. In most cases, I would agree with r937 that fewer tables with more rows are generally better.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Sep 2011
    Posts
    4

    How to determine?

    Quote Originally Posted by r937 View Post
    the latter

    Thanks a lot.
    I had the same feeling.

    This raise other question, request you to calrify

    In my plan of implementation will be using MySql. One table will grow upto 1 million records per year and this table will updated and queried heavily, how will the performance be affected? On a average there might be about 350 update threads and about 300 query threads happening almost at the same time.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    performance depends on existence of proper indexes on the table, and also on server tuning
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Sep 2011
    Posts
    4
    Since I have good number of updates happening, Indexes will affect the performance. Pl advice?

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Quote Originally Posted by vknadagouda View Post
    Since I have good number of updates happening, Indexes will affect the performance. Pl advice?
    They will improve the performance of your update if the index covers your WHERE condition

  8. #8
    Join Date
    Sep 2011
    Posts
    4
    I thank all the members for sharing the knowledge.

    Request is there any other feature which can be used in MySql to improve performance apart from server and optimizer tuning, pl let me know.

Posting Permissions

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