Re: [sqlite] OR, IN: which is faster?

Thank you , Joe Wilson. 2007/2/3, Joe Wilson <[EMAIL PROTECTED]>: --- chueng alex1985 <[EMAIL PROTECTED]> wrote: > I don't think so. If the field has been indexed, searching speed will be > imprved very much. The query "f1 = value1 OR f1 = value2 OR f1=value3 O

Re: [sqlite] OR, IN: which is faster?

I don't think so. If the field has been indexed, searching speed will be imprved very much. The query "f1 = value1 OR f1 = value2 OR f1=value3 OR ..." will be faster if the field f1 has been indexed. On the other hand, the clause "f1 in (value1, value2, value3, ...)" seems to be slower then 'OR'

[sqlite] How to lock sqlite DB when access it

I want to lock a DB when I access it, in case of two processes write/read it at the same time. Forgive my poor english. Thank you.