Re: Querying a database for 50 users' information: 50 queries or a WHERE array?
| From: | Dotan Cohen | Date: | Wed, 14 Sep 2011 08:12:03 +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 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-314838@lists.php.net to get a copy of this message | ||
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