Subject RE: RE:Jason, [IBO] Speed question
Author Nico Callewaert

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,

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


> My users interact with the data like discribed below. All
> IB_Queries (not even one IBoTable), to retrieve data and to insert
> 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
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
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
hard disks, using an array for performance, better hardware like
controllers, faster CPU's, more memory, and so on.

Jason Wharton
CPS - Mesa AZ

------------------------ Yahoo! Groups
Sponsor ---------------------~-~>
Make good on the promise you made at graduation to keep
in touch. has over 14 million registered
high school alumni--chances are you'll find your friends!

Your use of Yahoo! Groups is subject to

Stamp powered by

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