On Sun, Apr 18, 2004 at 11:04:14AM -0700, Chris Waters wrote: > The idea is that I can iterate through a set of records with the cursor, > updating as I go. The challenge is working out how to implement the > UpdateRow() function. I am happy to accept the costraint that the query must
> Implementing another layer of SQL parsing is less than ideal since I have > found that the parser already dominates sqlite performance for my tests > (in-memory DB with many different queries using indexes). Why do you want to write special C cursor code rather than just using a single SQL update statement? Performance? If so, maybe it would be better to create a way to just cache and re-use the SQL query plan, rather than throwing out the use of SQL altogether? -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
