SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Addict
    Join Date
    May 2002
    Location
    Louisville, KY
    Posts
    238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how many rows are too many rows?

    I'm simply wondering what you all think... I'm developing a site that has the potential of having over a thousand entries in one table. (Let alone having multiple tables with hundreds of other things). Suppose I have organized this table with a column for 15 different categories and did a "SELECT * FROM table WHERE category='whatever';"... how long would a query like this take? is it noticibly longer when pulling up the page that performs this query? i do not understand the potential of mysql. i'm wanting to know my boundaries... (if their are any)

    Do any of you have experience with this or can offer advice?

    THANKS!
    JP

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,020
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by jpfour23
    Suppose I have organized this table with a column for 15 different categories and did a "SELECT * FROM table WHERE category='whatever';"... how long would a query like this take?
    less than a hundredth of a second

    did you mean one category column or 15?

    were you planning on a category table?
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    We like music. weirdbeardmt's Avatar
    Join Date
    May 2001
    Location
    Channel Islands Girth: Footlong
    Posts
    5,882
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1000 rows is small potatoes... big databases have millions and millions and function pretty well... the major factor will be the design of the database etc.
    I swear to drunk I'm not God.
    Matt's debating is not a crime
    Hint: Don't buy a stupid dwarf Clicky

  4. #4
    SitePoint Addict
    Join Date
    May 2002
    Location
    Louisville, KY
    Posts
    238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    just one category column with 15 different categories. although, once i have this designed i'll probably have a category table.

    so really that fast huh? that's amazing? what are the limits? i mean 10,000 rows?? 100,000 rows?

    by the way... since you're an SQL pro.. got any books you'd recommend? i have an old MySQL book, several PHP & MySQL books... and just bought "mySQL Tutorial".. simple book. just having a hard time understanding certain things... like sophisticated joins, etc.

  5. #5
    SitePoint Addict
    Join Date
    May 2002
    Location
    Louisville, KY
    Posts
    238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    just got you're response weirdbeardmt...

    how about this one guys:
    suppose i had 100 sites hosted on my server... all of which were database driven sites accessing mysql. i have 1gig ram and a super fast p4 processor. say these sites used 10gb bandwidth each month. now obviously mysql will be working its butt off. is this okay? can i expect mysql to crash a lot? how can i monitor its performance?

    thanks,
    jp

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,020
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    learn mysql caching
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •