Subject Getting the last inserted row ID
Author Federico Tello Gentile
In the JayBird FAQ says that in order to get the last inserted row ID
when using a trigger to generate that ID with a generator it is
recommended to query first to generate the ID and then insert it
having the trigger not generate a new one when it is provided. I am
currently using a different approach, I'd like to know your opinions
about it.
What I do is:

select max(id) from table;

Is it much more inefficient? My app is a not inserting more than 10
rows at a time. It is an interactive application with only one user.