>> For LAST_INSERT_ID(), the most recently generated ID is maintained in
>> the server on a per-connection basis.
>
> Wouldn't adding a simple line to auto-increment triggers do the same?
>
> create trigger
> ...
> new.autoinc = gen_id(some_generator, 1);
> RDB$SET_CONTEXT('USER_SESSION', 'LAST_INSERT_ID', new.autoinc);
> ...
>
Yes, that is my strategy for now.
However, currently I am evaluating how Joomla works using the Java-based
PHP compiler, and if it works fine for MySQL, then I will perform
porting extending that PHP interpreter first. It is easier for me
because of integrated environment (Eclipse supports Java and PHP) but
also it gives performance boost as well - Drupal CMS works 4x faster
than on "native" PHP.
Roman
|
