Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    12

    Unanswered: How many row entries before a table gets slow?

    If I have a table with nine fields, 7 are int and 2 are datetime, how many rows is it likely to handle before it starts to slow up a bit?

    Just curios to what different peoples opinions might be?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Tables don't get slow...

    Queries that retrieve the data are the things that take time.
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2008
    Posts
    12
    So if for example there are 800,000 (or more) rows in a table and I have a query that is pulling back the values of 3 or 4 rows based on a specific where clause would it still be as quick if there were only 1,000 rows?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if the query is making use of indexes to restrict the rows returned yes, if it requires a table scan no (ie it has to search through every row to find the data)....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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