Jason,

Thanks for your information, at least I can sleep good tonight
without having nightmares of bad queries, :-)

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


Nico,

Sounds OK to me what you are doing. I wouldn't worry about it until
a
problem appeared.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Nico Callewaert" <nico.callewaert@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 14, 2001 12:13 PM
Subject: RE: RE:Jason, [IBO] Speed question


> 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]
>
>
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>


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