Performance

[BigMag]

I (DB2 background, with knowlegde of indexes) stated that the performance of SQL server on a large table (1000000 records) is at least as fast as the performance of SQL server on a small table (100 records).

Someone else stated otherwise.

We both can't prove who's right.

So if anyone can tell me (and prove it), we won't need to archive (yet).

yours truly

BigMag

mailto:someone@euronet.nl (No kidding!)

 

[foxdev]

"the performance" is pretty wide-open. I think first you'll need to narrow down the definition of performance, specifically in what operation.

For example:

* returning a single row using an ad-hoc query

* returning a row set consisting of X rows

* inserting a new row

* updating an existing row or rows

and so forth. I can imagine that under some circumstances certain operations would be nearly equivalent between 100 and 1 million rows, but that may well be hardware dependant as well. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com