How many system objects do you have that this is a problem? > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of sanhua.zh > Sent: Sunday, 9 October, 2016 21:53 > To: sqlite-users > Subject: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table Count Grow > > I foundCREATE TABLE/ALTER TABLE Slow Down When Table Count Grow. > Since those SQLs modify the schema, SQLite use theOP_ParseSchema to update > them, which cause the search of sqlite_master. (SELECT name, rootpage, sql > FROM '%q'.%s WHERE %s ORDER BY rowid) > As we all know, sqlite_master has no index except rowid. So this search > may slow down when the table count grow, since it cause a full-table- > search. > > > Is there anyway to solve this problem? > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
