Re: Querying a database for 50 users' information: 50 queries or a WHERE array?
| From: | Eric Butera | Date: | Wed, 14 Sep 2011 13:02:38 +0000 |
| Subject: | Re: Querying a database for 50 users' information: 50 queries or a WHERE array? | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-314842@lists.php.net to get a copy of this message | ||
On Wed, Sep 14, 2011 at 4:12 AM, Dotan Cohen <dotancohen@gmail.com> wrote:
> On Wed, Sep 14, 2011 at 06:05, chetan rane <chetan.d.rane@gmail.com> wrote:
>> Hi,
>>
>> There are 2 peoblems with subselect
>>
>> 1. You cant use a limit on the nested select
>> 2. Id the number of elements in the in clause exceeds the subselect buffer
>> you will run into performance issues ans eventually you query will be
>> doomed. Inner joins in,this is the best option for this . You can use a temp
>> table for this
>>
>
> Thanks Chetan. I will keep that in mind if I ever get around to
> learning about subselects.
>
> Have a great day!
>
> --
> Dotan Cohen
>
> http://gibberish.co.il
> http://what-is-what.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Just out of curiosity, where are these ids coming from? Doing a raw
implode on them like that is a sql injection vuln.