On Wed, Aug 4, 2010 at 6:10 AM, lei liu <[email protected]> wrote: > Because my company reuire we use 0.4.1 version, the version don't support IN > clause. I want to use the OR clause(example:where id=1 or id=2 or id=3) to > implement the IN clause(example: id in(1,2,3) ). I know it will be slower > especially when the list after "in" is very long. Could anybody can tell me > why is slow when use OR clause to implement In clause? > > > Thanks, > > > LiuLei >
I can not imagine the performance difference between 'or' or 'in' would be that great but I never benchmarked it. The big looming problems is that if you string enough 'or' together (say 8000) the query parser which uses java beans serialization will OOM. Edward
