2008/9/30 Milan Babuskov <milanb@...>:

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

Thanks for the hint.

But I simply don't want the table to grow as big as it did. :-)
I keep sortids only on tables that have a maximum of 1.000 entries.
Otherwise it wouldn't make that much sense to manually sort them,
imho...

--
eat(this); // delicious suicide