>>>"John Buckman" said:
> Another thought we had was to make SQL work with fileevent, so that it is
> readable when the query results come back, and writeable once the currently
> pending query is finished. On a certain level, a SQL connection really is
> a TCP/IP connection (behind the nasty Oracle API), so it does behave like
> an io device.
>
> However, I haven't looked at how fileevent works to see how we'd hook our
> C++ stuff on top of it.
There may be code inside the latest Sybtcl or Oratcl to do this.
I know that Tom Poindexter was experimenting with this. There is
apparently one issue, however, in that you can select() on the
socket while you are wiating for the query to execute, but
once you start getting rows back the Oracle APIs make it awkward
or even impossible. I don't know the details, and I think it
would be OK anyway as once you start getting rows it doesn't matter.
The big wait ocurrs while the query is being processed.
-- Brent Welch <[EMAIL PROTECTED]>
http://www.ajubasolutions.com
Scriptics changes to Ajuba Solutions
scriptics.com => ajubasolutions.com
