On Fri, Aug 4, 2017 at 6:03 PM, petern <peter.nichvolo...@gmail.com> wrote:
> About the H2 test. That tester actually uses 10e6 is 10 x 10^6, 10 million > rows. When I wrote you I forgot I bumped it up to 10 million since 1 > million was only half a second on the native case. Give that a try on H2 > and you'll see 22s goes to above 200s. > > > > CREATE SEQUENCE IF NOT EXISTS SEQ_TEST START WITH 1; > > CREATE TABLE SEQ_TEST(seq_num INT UNIQUE NOT NULL); > > > > insert into SEQ_TEST(seq_num) > > select seq_test.nextval from SYSTEM_RANGE(1, *1000000*) > > ; > no, the H2 test case was 1 million. (my computer might be terribly slower than yours) and I also used 1 million for my sqlite test case, so I was consistent. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
