Subject | Speed question |
---|---|
Author | Nico Callewaert |
Post date | 2001-03-14T18:29:15Z |
Hi,
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
ncw@...
nico.callewaert@...
[Non-text portions of this message have been removed]
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
ncw@...
nico.callewaert@...
[Non-text portions of this message have been removed]