On 23 Jan 2002, at 19:01, Doug Chamberlin wrote:

> At 01/23/2002 06:26 PM (Wednesday), Sandeep wrote:
> >Is it a good idea to use stor proc?
> >
> >Well if it is then while..do doesn't works properly in FBRC2.
> >Any workarounds?
>
> This is most unhelpful without more details. What exactly is not working
> for you? What should be worked around?

sorry about those remarks, The stored proc never got to while
statement, so I thought it hangs the Server, but what I found it was
not that. It was a select statement just before while..do loop that
caused the server to read all the records in the table, it shouldn't as
the table has got a proper index on it.

The reason for it being slow is due to the fact that I have
date_field < current_date in where clause, but if I replace it with
date_field = current_date then it doesn't takes that long.

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz