Re: [SOCI-users] Asynchronous queries

[Artyom <art...@ya...>]

Hello,

Just for the record, from 3 pupular FOSS databases:
PostgreSQL, MySQL and SQLite3 only PostgreSQL has an API
allowing asynchronous requests to DB. I don't know about
the others.

Even if this can be done on SOCI level, it will have very limited
support from backends.

> Myself, I am using a threading solution in userland and I
> need to 
> replace blocking calls by asynchronous equivalents as to
> not block all 
> threads.

I think this is correct solution, because you usually can't create 1000
simultanious connections to DB so, threading will do the job well.
There no too much sense create tight asynchronous application 
that does lots of requests to DB, because DB becomes the bottle neck
very fast.

So if you have something that does lots of asynchronous job,
and some of operations goes to DB just create a requests queue,
and responds queue, attach them to some kind of thread pool and 
work with this queues form main async. loop this would work more
then fine.


--- On Tue, 9/23/08, Mathias Gaunard <lou...@gm...> wrote:

> From: Mathias Gaunard <lou...@gm...>
> Subject: [SOCI-users] Asynchronous queries
> To: soc...@li...
> Date: Tuesday, September 23, 2008, 1:14 AM
> Hi,
> 
> For an application that needs to handle a lot of taks
> concurrently 
> without kernel threads, I think having asynchronous queries
> would be 
> very useful.
> 
> 
> Could the supported RDBMS even support that kind of thing?
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move
> Developer's challenge
> Build the coolest Linux based applications with Moblin SDK
> & win great prizes
> Grand prize is a trip for two to an Open Source event
> anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Soci-users mailing list
> Soc...@li...
> https://lists.sourceforge.net/lists/listinfo/soci-users