Re: one query or multiple queries

2007-09-28 Thread Ian Lea
I'd guess the latter would be faster, but who knows? Try it both ways. -- Ian. On 9/28/07, Xuesong Luo <[EMAIL PROTECTED]> wrote: > Hi, there, > I have a user index(each user has a unique index record). If I want to > search 10 users, should I run 10 queries or 1 query with multiple user > ids

one query or multiple queries

2007-09-28 Thread Xuesong Luo
Hi, there, I have a user index(each user has a unique index record). If I want to search 10 users, should I run 10 queries or 1 query with multiple user ids? Is there any performance difference? Thanks Xuesong

one query or multiple queries

2007-09-27 Thread Xuesong Luo
Hi, I have a user index(each user has a unique index record) and need to get information for 10 users. Should I run 10 queries or 1 query with multiple user ids? Any performance difference? Thanks Xuesong