On Fr, 30 Okt 2009, preining wrote:
> Only one question, if one of you has some experience with sql (as
> I don't). How does one specify a LIST of ids to be removed in a 
> single sql statement?

One more thing while digging throught he code. Maybe using the
transaction feature would be nice. For insert/updates a transaction
is started.

If this is possible for the delete, too, one could set the transactions size
with --sqlite-transaction-size=1000000 and then in fact only one
time the whole stuff would be committed, AFAIU.

Best wishes

Norbert

-------------------------------------------------------------------------------
Dr. Norbert Preining                                        Associate Professor
JAIST Japan Advanced Institute of Science and Technology   prein...@jaist.ac.jp
Vienna University of Technology                               prein...@logic.at
Debian Developer (Debian TeX Task Force)                    prein...@debian.org
gpg DSA: 0x09C5B094      fp: 14DF 2E6C 0307 BE6D AD76  A9C0 D2BF 4AA3 09C5 B094
-------------------------------------------------------------------------------
IPING (participial vb.)
The increasingly anxious shifting from leg to leg you go through when
you are desperate to go to the lavatory and the person you are talking
to keeps on remembering a few final things he want to mention.
                        --- Douglas Adams, The Meaning of Liff



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to