Having had a bit of a look - I agree that it's not his code - he's just got a fantastic site that's getting a pretty awesome volume of traffic - As far as I can tell, it's the most heavily trafficked Cold Fusion site on our shared platform and every now and then he's swamping the connection pooling enough that more then 35 concurrent connections are running. Other then some minor tuning of his queries - there's not much he could possibly have done except have a look at a dedicated SQL server. It says a lot about the quality of his application that it can handle as much traffic as it does from a shared platform to begin with.
Barry Beattie wrote: > in that case my curiosity has been piqued... > > only closed connections can be returned to the pool, yes? > > what would be keeping a bunch of connections open? > > excessively long queries? a cftransaction gone silly? a trapped error > running a query, taking too long to get resolved? > > pity it's not cf8 with monitoring tool. got SeeFusion handy? > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---