Обсуждение: Performance Issues

> John Menke schrieb:
>
> I am in the design phase of a new database that contains one very long
> thin table.  Are there any peformance issues with index lookups to a
> table like this if table becomes extremly long?  Lets say hundreds of
> thousands to millions of records...  Remember, the table only has one
> column.
>
> Another question.  If the size of data in this record were to vary
> greatly, would that have an impact on performance?
>
>

 insert and updates times may grow linear if you've indices,
otherwise selects will be pretty stable.

 Marten