Growing size of table: slow performance and solutions

• johnsql-193053

  SSCommitted

  Points: 1657

  More actions

  December 9, 2006 at 7:34 am

  #175184

  Hi,

  I have a question about the performance of database. Overtime, rows are inserted into a table and the table becomes bigger and bigger. So, if we perform a query command like “SELECT” or “UPDATE” or whatever, because the table are bigger than before, then processing time of queries or database performance are worse accordingly??? Selecting rows must consume more time to filter rows among rows whose population is larger than before???

  If so, what are the best solutions to solve the problem?

  Thanks

  Johnsql

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  December 9, 2006 at 9:54 am

  #677121

  I responded to this here:

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76148

  ---------------------------------------
  elsasoft.org