Daniel Albuschat wrote:

> (gen_id(table_gen, 1), :name, (select max(sortid) from table) + 1)".
> The subselect grew ever bigger and slower as more entries have been

You need DESC index on sortid field.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com