Re: [boost] ASIO Query

Subject: Re: [boost] ASIO Query
From: james_at_[hidden]
Date: 2011-12-21 15:21:36

Blocking - I've thought about this, but the MySQL C/C++ libraries unfortunately
don't provide asynchronous queries.
 
I'm thinking of moving database reads into a seperate thread(s). It would be
nice if I can integrate this with the io_service, but I'm unsure how to do so.
Is it possible to pass arbitrary work items to an io_service, in the same manner
as async_read/write?
 
Many thanks. 

 

On 21 December 2011 at 16:07 Olaf van der Spek <ml_at_[hidden]> wrote:

> On Wed, Dec 21, 2011 at 3:27 PM, james_at_[hidden]
> <james_at_[hidden]> wrote:
> > I'm hoping for opinions on using an io_service per core against a single
> > io_service with multiple threads (similar to HTTP Server examples 2 & 3).
> > The
> > application is a TCP authentication / proxy server, intended to use all
> > available cores.
> >
> > - The TCP streams consist of small messages (usually a few hundred bytes)
> > which
> > can individually be processed quickly.
> > - Connections themselves are fairly long lasting - average around 4 hours,
> > although occasionally up to 10-12 hours.
> >
> > We're looking for a 'shared nothing' design between threads - database
> > queries
> > can be made per-thread (using TLS), for example.
>
> Are database queries blocking or non-blocking? If they're blocking,
> won't this also block other connections handled by the same thread?
>
> Olaf
>
> _______________________________________________
> Unsubscribe & other changes: http://lists.boost.org/mailman/listinfo.cgi/boost