mysql-native: newbie questions

[Steve Teale]

On Tuesday, 8 April 2014 at 14:10:19 UTC, simendsjo wrote:
> On 04/08/2014 04:00 PM, Steve Teale wrote:
>> On Tuesday, 8 April 2014 at 07:58:58 UTC, simendsjo wrote:

On a more specific topic, Nick S mentioned purging of result sets.

I have a mixed view of this. One half of me says "if you cant 
present a SQL query that selects what you want, then put up with 
the inefficiency of waiting for the thread to read through all 
the stuff until it finds an EOF".

The other half wonders if there should be a connection pool, and 
then situations like that could just switch to a new connection, 
and leave the existing one at lower priority to clean up the 
garbage.

But the latter is not systems programming approach.

Writing that down cleared my mind. The level we should aim at 
should I think be just what is needed to exploit the capabilities 
of the MySQL/MariaDB protocol version. The protocol is what it 
is, and is unfriendly toward sloppy SQL.

Steve