subject:"\[sqlite\] CREATE TABLE\/ALTER TABLE Slow Down When Table CountGrow"

Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow

2016-10-10 Thread Simon Slavin

On 11 Oct 2016, at 3:45am, sanhua.zh wrote: > I’m altering the all table's names, which takes a long time to finish. > But now, I use ‘PRAGMA writable_schema=ON’ to alter them, which is written > athttps://www.sqlite.org/lang_altertable.html > Although it is easy to

Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow

2016-10-10 Thread sanhua.zh

be no problem 原始邮件发件人:Simon slavinslav...@bigfraud.org 收件人:SQLite mailing listsqlite-us...@mailinglists.sqlite.org 发送时间:2016年10月10日(周一) 17:03 主题:Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow On 10 Oct 2016, at 4:52am, sanhua.zh sanhua...@foxmail.com wrote: I

Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow

2016-10-10 Thread sanhua.zh

more than 1 tables/indexes 原始邮件发件人:Keith medcalfkmedc...@dessus.com 收件人:SQLite mailing listsqlite-us...@mailinglists.sqlite.org 发送时间:2016年10月10日(周一) 12:48 主题:Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow How many system objects do you have that this is a problem