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

On 10 Oct 2016, at 4:52am, sanhua.zh wrote: > I foundCREATE TABLE/ALTER TABLE Slow Down When Table Count Grow. Yes. SQLite needs to search through the (hashed) list of tables every time you give it a command that uses tables. The more tables there are, the longer it

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

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 TABL

[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