On Sat, 2008-03-01 at 10:58 +1300, Lee Begg wrote:
> On Sat, 01 Mar 2008, Qusai Al Shidi wrote:
> <snip>
> > And what I
> > should keep in mind while making my SQL abstraction code? Thanks :).
>
> Oh, just remembered. If you see a way to do asynchronous DB transactions
> please let me know. IE, expose a file descriptor for use in a select loop and
> get result back via callback, without using threads. I believe that the
> blocking database queries are the slowest things in tpserver-cpp (other than
> EOT processing).
The documentation to do that in mysql & postgresql is part of the
standard examples. Essentially when you connect you ask for the FD,
then use the async call all the time.
And performance wise, it's the way to do it... much quicker.
Regards,
nash
_______________________________________________
tp-devel mailing list
[email protected]
http://www.thousandparsec.net/tp/mailman.php/listinfo/tp-devel
