Ann W. Harrison wrote:

> Kjell Rilbe wrote:
>>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
>
> Don't underestimate the efficiency of a stored procedure. On first
> reference, the stored procedure is converted to a set of execution
> steps, optimized for the current size and structure of the tables and
> indexes involved. The SQL is long gone.

I know that (well, most of it anyway). That's why I estimated that the
performance loss there would be less than the performance loss caused by
a larger dataset being transferred via TCP/IP, even though the TCP/IP
connection is local.

Still, I'd like to keep the number of non-portable "utility objects" in
my database to a minimum, so I try to avoid SP:s. The application
currently supports both SQL Server and Firebird and I'd like to expand
that list rather than reduce it.

Thank you allthesame,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64