As can be guessed populating table is quite slow - ~150ms for around 10k rows
in IndexME.
Why do you think it's slow? 6 rows per second is insanely fast.
Pavel
On Sun, Oct 2, 2011 at 5:49 AM, Mira Suk mira@centrum.cz wrote:
Hey everyone,
currently I have some temporary table
Hey everyone,
currently I have some temporary table which I populate this way (recursive
triggers on)
CREATE TEMPORARY TABLE IF NOT EXISTS NestedEntriesResult_ID (IDX INTEGER NOT
NULL, DBORDER INTEGER PRIMARY KEY NOT NULL);
CREATE TEMPORARY TRIGGER IF NOT EXISTS NestedEntriesPopulate_ID