>>>>> "Rob" == Rob Bloodgood <[EMAIL PROTECTED]> writes:
Rob> Does anybody know of a way to run a non-blocking DBI query?
Rob> Non-portable is ok with me, if it works with Oracle! :-)
I've heard rumors that there's been investigation into
some form of asynchronous DBI calls, but I don't think anything's been
done yet. What I've been doing is using POE::Wheel::Run to start up a
few seperate helper processes which make all the DBI calls. There's a
queue that has a next() method that returns the next available helper
in a round robin fashion. The helper is just a while loop that reads
requests, parses out the relevant data (split /\|/, $req), executes a
pre-prepare'd statement, and then prints the result back to the main
process.
Not exactly what you're looking for, but it's fairly easy to
implement and will work with any backend database.
--
Fletch | "If you find my answers frightening, __`'/|
[EMAIL PROTECTED] | Vincent, you should cease askin' \ o.O'
770 933-0600 x211(w) | scary questions." -- Jules =(___)=
| U
