> Michael Van Canneyt wrote: > > > My point of view is that a database is for storage, not for logic... > > Ah, this is basic use of resources. The benefit of Stored Procs is speed > of execution.
For dialy routines, only if they are not complex, and significantly reduce the amount of data transfered tuples (the result set), and it can not be expressed in a query. With complex I mean is that if the stored proc needs to use temp tables or other state that consists out of a set of tuples, then it is usually slower. Oh, and CPU is cheap compared to DB licenses nowadays. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
