On Fri, Aug 4, 2017 at 7:41 AM, petern <peter.nichvolo...@gmail.com> wrote:
> Sylvain, are you happy with the performance?
>
> Maybe you are using it differently but, from my tests, the DEFAULT clause
> is ignored for PRIMARY KEY columns. I had to use an ordinary column with
> UNIQUE constraint to test your extension. Below is a tester for 1 million
> rows which completes in about 186 seconds. The same million row test with
> PRIMARY KEY column (and ignored DEFAULT) completes in about 5 seconds.
>
Hi Peter,
I am not using the sequence as default, but I use it explicitely like
insert into T (T_ID) values (seq_nextval('seq'))
I generally create few hundred rows in my app, so I won't see any
performance issue,
Nevertheless, I am surprised to see so much difference between my UDF and
the trigger implementation.
Does anyone have an idea how to improve it? (using the same approach -> the
sequence is in a table)
Best regards,
Sylvain
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
