Subject Speed question
Author Nico Callewaert

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, ...., does
it mean that the execution of the statements will always slow down, the more
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 the
database will grow ?

Thanks in advance,

Nico Callewaert


[Non-text portions of this message have been removed]