Subject | RE: [IBO] IB_Query/SP/KeyLinks |
---|---|
Author | Helen Borrie |
Post date | 2004-10-29T12:06:56Z |
At 09:12 PM 29/10/2004 +1000, you wrote:
idea. If you want filtering on a virtual table, you use the procedure
itself to restrict the set, by passing your limiting criteria in the input
parameters. Otherwise, the SP has to generate every row that the SP is
capable of generating and then screen each row as it is output.
The *right* (read quick, responsive, low-calorie) way to do this is to
define SPs that have the "where" criteria in the input params and then use
those inside the SP to select the rows. This way, the SP handles only the
data the client actually wants AND it can use indexes. Same story with
ordering criteria, if you can manage to live without OrderingItems, et al.
Helen
>?? I use WHERE clauses on SSPs all the time. There can be, and it worksI meant to comment that using WHERE clauses on SSPs is a really naf
>from the server,
idea. If you want filtering on a virtual table, you use the procedure
itself to restrict the set, by passing your limiting criteria in the input
parameters. Otherwise, the SP has to generate every row that the SP is
capable of generating and then screen each row as it is output.
The *right* (read quick, responsive, low-calorie) way to do this is to
define SPs that have the "where" criteria in the input params and then use
those inside the SP to select the rows. This way, the SP handles only the
data the client actually wants AND it can use indexes. Same story with
ordering criteria, if you can manage to live without OrderingItems, et al.
Helen