Web lists-archives.com

Re: Merging multiple SQL requests




Thanks for the response!

Looks like the only way MySQL server would merge requests is based on
keywords used by client side, such as UNION etc. If client doesn't
specify such keyword, the server won't automatically merge multiple
requests.

I'm now profiling the MySQL code to identify the root-cause...

Thanks!


On Sat, Feb 21, 2015 at 5:33 PM, Jay Ess <lists@xxxxxxxxxxxxxx> wrote:
> On 2015-02-15 23:55, Learner Study wrote:
>> Hello experts,
>>
>> Is it possible for MySQL server to automatically merge responses for
>> different queries into a single response? Are there any kernel
>> parameters that may dictate that?
>
> "UNION is used to combine the result from multiple SELECT statements into a
> single result set."
> http://dev.mysql.com/doc/refman/5.0/en/union.html
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql