Jason,

To search records for let's say customers, I have a seperate form (a
searchform that is used for all datasets), with a Grid and a searchedit,
once the user selects the record he likes, I open a query that is set (no
search anymore), that retrieves just that one record of interest. After
that if the user likes another record, he can open the searchform again and
select another record again, ....... I hope I gave you some more
information, am I doing the right thing ?
Jaso, I think it's a pitty I'm not working where you are working, probably I
will ask questions the whole day, hahaha, :-)

Thanks again,

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


Nico,

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

Well, it doesn't give me any more information to go on. If your
queries are
set and not dynamic (meaning the user is given choices of search
criteria)
then you can always make sure they are going to perform well. If
they are
given the ability to do dynamic queries they will eventually learn
which
searches are slow and which are fast.

> And what do you mean with "to increase the horsepower" of your

server ?

Well, there are many things that affect server performance. Better
quality
hard disks, using an array for performance, better hardware like
caching
controllers, faster CPU's, more memory, and so on.

HTH,
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]