Thanks, that was very helpful. In fact it looks it as many times faster as the number of fields to be done, so in my particular case 5 times faster! Maybe somebody who knows the inner workings of SQLite could explain why this is. Will see if I can apply this to some other places in my app.
RBS > SQLite supports a syntax like this: > > UPDATE newTable SET > field1 = (SELECT field1 FROM oldTable T WHERE PATIENT_ID = T.PID), > field2 = (SELECT field2 FROM oldTable T WHERE PATIENT_ID = T.PID), > field3 = (SELECT field3 FROM oldTable T WHERE PATIENT_ID = T.PID); > > I'm not sure this is going to be significantly faster than the loop you > have now. Unfortunately, SQLite doesn't support UPDATE...FROM syntax > some other engines use, as in > > -- doesn't work with SQLite > UPDATE newTable SET > field1=T.field1, field2=T.field2, field3=T.field3 > FROM oldTable T WHERE PATIENT_ID = T.PID; > > Igor Tandetnik > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
