On 02/09/2011 08:26 AM, Roger Oberholtzer wrote:
I am guessing I can do this via the sqlite3 command?
Yes.
I am never sure about the BEGIN TRANSACTION / COMMIT stuff. Do I need to put that around the DELETE statement?
Only if you care about being able to roll back a set of commands if one of them fails. Short version: No.
(Despite these questions, I am a C/Tcl/ASM/etc. programmer. Just not so familiar with SQL.)
It's easier than it looks. The query optimizations are a bit of a black art, but most DB's provide instrumenting so you can see where it is spending its time.
-- Matthew Caron Build Engineer Sixnet | www.sixnet.com O +1 518 877 5173 Ext. 138 F +1 518 602 9209 [email protected] -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
