Jason,

My users interact with the data like discribed below. All
IB_Queries (not even one IBoTable), to retrieve data and to insert data,
connected to data controls. I hope this is good ?
And what do you mean with "to increase the horsepower" of your server ?

Thank you

Nico
-----Oorspronkelijk bericht-----
Van: Jason Wharton [mailto:jwharton@...]
Verzonden: woensdag 14 maart 2001 19:43
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Speed question


Nico,

> 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 ?

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
http://www.ibobjects.com



------------------------ Yahoo! Groups
Sponsor ---------------------~-~>
Make good on the promise you made at graduation to keep
in touch. Classmates.com has over 14 million registered
high school alumni--chances are you'll find your friends!
http://us.click.yahoo.com/l3joGB/DMUCAA/4ihDAA/P0AVlB/TM
--------------------------------------------------------------------
-_->



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/




Stamp powered by www.mailround.com




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