Subject Re: [firebird-support] FB sql compilation: buffered or not?
Author Martijn Tonies

> >>In that light is makes
> >>sense to tell RDBMS that some statements have to be in the buffer
> >>permanently, e.g. those executed 10x per second. Well, this is
> >>probably as the buffer is not shared between connections.
> >>
> >>
> >>
> >Something that is likely to appear in a future version is a compiled
> >statement cache which will be cross connection.
> >
> Ah ha!!!
> That would be excellent!
> Especially as, over a slow connection, the slowest thing is the
> prepares. So if you only have to do it once, for all the users, it could
> make things much faster.
> Would this cache be persistent (that is, you would be able to prepare
> statements once and for all), or would they get unprepared as soon as
> the transaction that prepared them gets closed?

Transactions don't get closed, they get committed or rolled back.

Prepared statements have nothing to do with transactions, only with

Of course, in a future release, this might be different, but implementation
has not yet started.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions