Post reply

Maximum number of rows.....Please advise

  • November 6, 2006 at 9:03 am

    #367978

    There is a table with millions of records and millions more would be added. There are proper indexes created on this database and it has right now 33 million rows. As of now the response time is acceptable. How many more millions can it take before the response time of the queries (both select and inserts) deteriorate by 25% and 50% ?

  • November 6, 2006 at 9:29 am

    #670108

    I would assume 25% and 50% more rows...  but the performance could still be very tolerable even with 200 M rows.  Depends on the server, the queries and the load you put on it.  You'll have to do load testing on a test server with the exact same specs to get that answer.  We can't just guess at this one...

  • November 9, 2006 at 3:09 am

    #670787

    Thanks for the quick response. I guess you are quite accurate.

  • November 9, 2006 at 6:27 am

    #670820

    Ya and judging by the lack of responses from other DBAS, I think it's right on the money.

     

    If you even encounter problems with performances on that table or any other.  Just post back and we'll help you get through it.

     

    God speed!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply