[fpc-pascal] Looking for a Firebird book?

[Marco van de Voort]

> Marco van de Voort wrote:
> > 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.
> >   
> I don't doubt what you are saying, but in my experience, this is not the 
> case. It really depends on the client and underlying protocol used to 
> access the RDBMS. In a local database system, yeah, probably. In a 
> RDMBS, no.

In my case, the middle tier was on a different machine than the (SQL Server)
db.

> Again, not true in my experience. Writing the same code on the client 
> that manipulates data from multiple tables and uses the resulting 
> dataset is a lot slower. Using Interbase/Firebird, you can create stored 
> procs that return datasets in a ad hoc fashion (multithreaded) or bulk. 
> Something like:

You example is prefectly covered by my exceptions, (it compares a case where
the stored procedure reduces the number of tuples returned). 

In (at least my) practice however, cases like this that can't be
expressed in SQL  (or at least that the first or second magnitudes of
data reduction are done) are relatively rare. 

> > Oh, and CPU is cheap compared to DB licenses nowadays.
> 
> Aha, the Microsoft defense! ;-) Chewbaka was a Wookie, don't you know? ;-)

I saw him whine yesterday in the Empire Strikes Back yes. And he was as
realistic as buying P-I client machines nowadays.