Subject RE: [IBO] IB_Query/SP/KeyLinks
Author Helen Borrie
At 09:12 PM 29/10/2004 +1000, you wrote:


>?? I use WHERE clauses on SSPs all the time. There can be, and it works
>from the server,

I meant to comment that using WHERE clauses on SSPs is a really naf
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