On 11/02/2008, at 5:15 PM, Sharon Rosner wrote: >> I like this as a compromise, but wouldn't it be possible to have >> Sequel use multiple mysql connections intelligently whenever >> required? >> Can we set some sort of 'in use' flag on a connection, and use >> another >> connection from the pool when the existing connection has this flag >> enabled? > > Yes it's possible but it could easily lead to deadlock situations
Plus you lose the transactional features, unless there's some way I'm unaware of to have the same session attached to more than one connection. You wind up getting two sessions which can get database deadlocks against each other. The same problem occurs with MS SQL due to a similar mis-feature in Sybase's TDS protocol. MS ADO works around it by creating a 2nd connection behind the scenes, but I've seen it outsmart itself and deadlock. Clifford Heath. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
