Helen Borrie wrote:

> At 09:41 PM 14/02/2005 +0100, you wrote:
> Why not just write a simple stored procedure that returns the result you
> want, and save bandwidth and client processing cycles?

Well, because the "client" is actually a server application that's
running on the same machine as the Firebird server, so it doesn't really
matter if the loop executes in Firebird or in the client. It all sits
behind a web server. I guess it comes down to choosing between one of
two performance hits:

1. doing a semi-compiled loop in SP language or SQL (using a view as per
Alan's suggestion) compared to a truly compiled loop in the application, or

2. transferring more data over a local TCP/IP connection.

I would assume that 2 degrades performance more than 1, but I wouldn't
think the performance hit is significant compared to other things, e.g.
executing the actual SQL in the first place.

But thanks anyway, I'll save the SP example.
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64