Re: [Firebird-devel] Simplify MySQL migration: LAST_INSERT_ID()

[Roman R. <ro...@ro...>]

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