Re: [Chicken-users] status of chickenlib: build process and mysqlinterface usage sample

[Joerg F. Wittenberger]

On Wed, 2004-09-01 at 18:53, Ed Watkeys wrote:
> Tony Garnock-Jones said:
> > Joerg F. Wittenberger wrote:
> >> I hardly have the time to look into that topic.  However I'd welcome a
> >> unified inteface very much (if it's not too simple, like that one
> >> http://groups.google.de/groups?q=oleg+scheme+database+group:comp.lang.scheme.*&hl=de&lr=&ie=UTF-8&group=comp.lang.scheme.*&selm=72nj6p%249n%241%40nnrp1.dejanews.com&rnum=1
> >> which is great for one shot programms, but hardly suited for performance
> >> sensitive apps).
> >
> > I'm curious - what about the interface makes it too slow?
> 
> I can only speak in general, but interfaces that return an entire result
> set consume lots of memory and can introduce lots of latency. For large
> result sets, the ability to get a row at a time allows for low-latency,
> constant-space programs.

Besides the fact that the mysql-code I sent today suffers from exactly
the same point and those modifications I'm plaaing because of DB2
address that issue:

Forking separate process requires to pipe the query and result set once
more than a direct DB connection.


Regards

/Jörg