Hello Richard Hipp, Thank you for the fast reply. We've confirmed that the work-around works well. We will remove UNIQUE from PRIMARY KEY by default.
Thank you again, -- Takasumi Iwamoto On Fri, Sep 16, 2016 at 11:17 PM, Richard Hipp <[email protected]> wrote: > Your best work-around is to fix your schema. Do *not* say > > UNIQUE PRIMARY KEY > > That is redundant. PRIMARY KEYs are always UNIQUE. Just say PRIMARY > KEY and omit the UNIQUE. > > Of course, SQLite should be able to deal with this redundancy without > a dramatic slowdown. That problem will be fixed in the 3.15.0 > release. We will also add test cases to try to prevent a recurrence > of this or similar problems. > > But in the meantime, just remove the UNIQUE from all your PRIMARY KEYs > and your performance issues should go away. For all versions of > SQLite. > > On 9/16/16, Richard Hipp <[email protected]> wrote: >> On 9/16/16, Takasumi Iwamoto <[email protected]> wrote: >>> Hello SQLite devs, >>> >>> We've found a hung-up issue in the current sqlite3. >>> Could you please read the below issue report? >> >> Thanks for the bug report. The ticket for this problem is here: >> https://www.sqlite.org/src/tktview/0eab1ac7591f >> >> -- >> D. Richard Hipp >> [email protected] >> > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
