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
has to search -- each ti
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
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 e
3 matches
Mail list logo