Subject | RE: [firebird-support] Connection overhead |
---|---|
Author | Ann W. Harrison |
Post date | 2004-12-20T22:21:45Z |
At 04:49 PM 12/20/2004, Rick DeBay wrote:
We actually considered statement pooling when designing the architecture
in the early dark ages and rejected the idea as using too much memory.
Happily, memory is somewhat more available now than it was in the early
1980's - well computer memory is, mine's pretty much shot - and one
reason for moving the DSQL processing into the engine is to be able
to maintain a cache of compiled statements for reuse.
Regards,
Ann
> > Doesn't it seem simpler just to eliminate the need for connectionOne of the goals of Vulcan is to pave the way to statement pooling.
>pooling with cheap connections?
>
>As long as you can have cheap connections, and we don't lose statement
>pooling in Jaybird (which I think still offers a scalability boost).
We actually considered statement pooling when designing the architecture
in the early dark ages and rejected the idea as using too much memory.
Happily, memory is somewhat more available now than it was in the early
1980's - well computer memory is, mine's pretty much shot - and one
reason for moving the DSQL processing into the engine is to be able
to maintain a cache of compiled statements for reuse.
Regards,
Ann