Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: speed issues

  1. #1
    New Coder
    Join Date
    Aug 2002
    Location
    PA
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    speed issues

    I currently have my website running off 1 mysql database with about 5 tables in it; some of these tables will hold ALOT of information; would it be a better idea to make another database and put the big tables in it by themselves..... also how many sql statements is too much... i have about 4-5 for each page; i was wondering if this would ever become a issue

    TIA

    p.s. all your base are belong to us
    Last edited by Roost3r; 10-29-2002 at 06:48 PM.

  • #2
    Mega-ultimate member
    Join Date
    Jun 2002
    Location
    Winona, MN - The land of 10,000 lakes
    Posts
    1,855
    Thanks
    1
    Thanked 45 Times in 42 Posts
    The real key will be normalization. Make sure your DB is in at least 3rd normal form and you should be good to go. Going to 4th Normal or Boyce-Codd Normal form can have some overhead issues.

  • #3
    New Coder
    Join Date
    Aug 2002
    Location
    PA
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts
    could you please explain tpo me what 3rd,4rth and boyce-codd normal is... i have no idea what you mean by that

  • #4
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Before diving into learning 3NF and BCNF you might want to learn more of the basics first. Data modelling is a rather extensive area to learn. You can find some links to tutorials in this thread to get you started:


    http://codingforums.com/showthread.php?s=&threadid=8811
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster


  •  

    Posting Permissions

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