in reply to Re: Long-running DB query makes Tk application unresponsive
in thread [solved] Long-running DB query makes Tk application unresponsive
I'm not bound to one DBD. The app currently talks to one of two databases, depending on user preference. One is SyBase, and I use DBD::ODBC for that connection. The other is Oracle and I use DBD::Oracle for that.
In the near future, Oracle will be the only choice, so I'd have no issue planning around DBD::Oracle.
DBIx::Threaded is a wonderful module! I got it working on my *NIX machines, and I was thrilled -- until I realized that ASPN hasn't managed to compile it into a ppd, yet. Unfortunately, unless the module is available on ASPN, the stupid policy prevents me from using it on Win32.
I'm figuring out how to implement a Thread::Queue solution as you suggested. I'm somewhat new to threads, so I'm taking my time on this one. Thanks for the suggestions! I'll update this if I end up succeeding on this approach. Any sample code you can provide that might help me get up and running more rapidly would be appreciated, as well.
|
|---|