All right,
I think I was missing a potentialy important info.
I am deleting rows as ranges.
It is up to SQLite how to do the deletation.
I am pushing ranges in a loop in the transaction.
Than the loop breaks signaling "busy" or "overwhelmed" state.
Without the transaction frame it is working fine.
-----Ursprüngliche Nachricht-----
From: Tibor Balog
Sent: Friday, December 8, 2017 7:11 PM
To: SQLite
Subject: [sqlite] Virtual table row deletition on trigger
Hello,
I run into a little anoyance regarding virtual table.
I have a contentless table:
CREATE VIRTUAL TABLE "OCR" using fts5 (content='',FullText)
bind with a trigger for row deletition:
CREATE TRIGGER "ART_AD" AFTER DELETE ON "ART" BEGIN INSERT INTO "OCR"
("OCR",rowid) VALUES('DELETE',old.rowid);END
It works as advertised however if I am deleting rows in transaction above
~20.000 rows put SQLite himself in “busy” state.
Is this a known limitation ?
That the virtual table row deletition triggered on normal table deletition
interfers with the normal table in transaction?
Info:
Im not using VAL, jurnal is in memory.
Latest build.
Thank You,
Tibor
_______________________________________________
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