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
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
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