On 3/15/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > On Wed, 15 Mar 2017, R Smith wrote: >> >> CREATE TABLE "test" ( >> "ID" INTEGER /* Here we add column comments */, >> "Name" TEXT /* Note the comma is AFTER the comment */, >> "EMail" TEXT COLLATE NOCASE /* Username (Unique Key) */, >> CONSTRAINT UI_test_EMail UNIQUE (EMail) /* This is an Index comment */ >> ) /* and this is a Table comment, before the final semi-colon */; >> >> This will be kept exactly as-is in the SQL field of the schema table >> (main.sqlite_master) and is easy to parse out later, or use a standard >> tool > > Are these comments loaded into memory used by each program which > connects to the database? If so, more resources are consumed.
The comments are loaded into memory temporarily while the CREATE TABLE statement is being parsed when the connection is first opened, but they are not held in memory long-term. The text of the CREATE TABLE is freed as soon as the schema parse completes. So there is no extra long-term memory usage. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
