Ann Harrison wrote:

>>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 impossible
>>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?

Thanks!

Jonathan Neve.



[Non-text portions of this message have been removed]