Try showing us an "explain" of your statements. Also seeing your table structure might help. I take it you have a lot of keywords (like multiple 100,000's) Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: [email protected] on behalf of sorka Sent: Wed 5/19/2010 1:01 PM To: [email protected] Subject: [sqlite] Delete from FTS3 with ROWID really really slow..... If I run the statement: delete from keyword where rowid in (SELECT idToDelete FROM keywordDeleteList); This statement takes an eternity even if there are only say 5 records in keywordDeleteList. Same thing if I do this: delete from keyword where rowid in (418458, 418541, 421168, 421326, 421367, 422676); However, this is very fast: delete from keyword where rowid = 418458 or rowid = 418541 <for each of the row ids> The problem is I can't use a previously calculated table as a delete list. I'd have to select each one, generate separate delete statement for each record in the fts3 table. I can't imagine why this is so slow. Any elegant work arounds? -- View this message in context: http://old.nabble.com/Delete-from-FTS3-with-ROWID-really-really-slow.....-tp28611977p28611977.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
