[mythtv] Scheduler needs table keys?

[Chris Pinkham]

* On Mon Jan 29, 2007 at 08:02:10PM -0600, David Engel wrote:
> On Mon, Jan 29, 2007 at 01:33:37PM -0500, Chris Pinkham wrote:
> > I thought about that, but we could potentially eat up a lot of connections
> > if a bug occurred.  
> 
> Couldn't we already?

Yeah, but there's much more potential for it if we're grabbing
DB connections and intentionally not using them immediately.

> > It might be possible to have a dedicated connection like
> > the scheduler does and just use that connection with multiple MSqlQuery
> > instances so that we can have multiple prepared statements queued up.
> > If the backgrounded processes are sequential then we wouldn't be writing
> > over ourselves with the single DB connection.  Something I'll have to test.
> 
> I'd be very concerned about re-entrancy problems with multiple
> foreground threads creating MSqlQuery object from the same DB
> connection at the same time.  Can that be done safely?

I don't know, possibly not.  Definitely would have to be
investigated and rigorously tested.

--
Chris