more than 10000 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? -----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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
