Well i guess my lack of understanding of the IB engine lead to that
reaction. but upon further thought I see how htis might be the case. oh
well!

thanks again!

rob

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 03, 2002 11:09 PM
Subject: Re: [IBO] Using Stored procedures exclusively


> This isn't to say that when queries INSIDE of the stored procedure are
using
> a WHERE clause that they cannot be optimized. I mean WHERE clause criteria
> on a SELECT procedure itself.
>
> Just thought I would clarify since your reaction seemed to indicate
> amazement. There's nothing to be amazed about. There is no way the stored
> procedure would know how to apply the WHERE clause on its output to
whatever
> you have done inside of it to derive the output.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Rob Schuff" <rob@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, April 03, 2002 9:51 PM
> Subject: Re: [IBO] Using Stored procedures exclusively
>
>
> > Well, that's a real shame. guess we'll have to do some testing to see
> > performance falls off. We typically have small apps so we may be able
to
> > get away with it. Is this particular optimization issue getting any
> > attention from the FB group or is it too big of an issue?
> >
> > thanks!
> >
> > rob
> >
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>