Subject Re: [IBO] Speed question
Author Jason Wharton

> I'm concerned about one thing. To retrieve data from a table, I always
> use IB_Query, take care of the fact to only retrieve the rows of interest,
> and I always check the plan, so I'm sure, the statement is using the right
> index. I have a table now with 35.000 rows, it's still going fast, but
> what if the table will grow to 100.000 - 200.000 - 300.000 rows, ....,
> it mean that the execution of the statements will always slow down, the
> rows in the table ? Do I have to tell the users of my application, that
> the longer they will use the application the slower it will get, because
> database will grow ?

This depends very much. I think in most cases you should not have any
problems but it depends on how your users are interacting with the data.
Even if you get up to 500,000 rows in a table, if you continue to increase
the horsepower of your server even not so great queries are tolerable.

Jason Wharton
CPS - Mesa AZ