How many system objects do you have that this is a problem? > -----Original Message----- > From: sqlite-users [mailto:[email protected]] > 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 > [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
