one query or multiple queries

[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

 

Re: one query or multiple queries

[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? Is there any performance difference?

 Thanks
 Xuesong