[cfaussie] Re: Connection Pooling
Hey Barry Well - could well be a scapegoat. i think my code is pretty clean and efficient. I dont have any long running queries apart from a few admin related ones. Some of the nav is generated from queries but this is all cached to avoid database getting hammered with each users request. So i guess i was looking here to check that isn't some cf code related connection pooling technique that i'm not aware of and that they indeed are just passing the buck. Wouldnt be the first time... Cheers Chris On Sep 21, 2:56 pm, Barry Beattie [EMAIL PROTECTED] wrote: Chris, are you sure they're not just picking on you and treating you as a scapegoat for some other problem? --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] L
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 -~--~~~~--~~--~--~---
[cfaussie] Re: MSSQL 2005 Developer Edition
You can get it in two editions, Express and obviously with the enterprise edition. That being said, you can manage the basics of a SQL 2005 server with the Studio Express edition... On 9/22/07, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: Yes, the developer edition comes with SQL Server Management Studio, the replacement/upgrade from EM. /charlie -- *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On Behalf Of *Steve Onnis *Sent:* Friday, September 21, 2007 5:25 AM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] MSSQL 2005 Developer Edition Has anyone got this and can they tell me if it comes with the SQL management tool? Like the new enterprise manager Steve Onnis Director / Head Developer [EMAIL PROTECTED] Australia : 1300 856 623 International : +61 3 9882 5875 0401 667 996 www.inevative.com.au http://www.novahost.com.au/ http://www.threesquares.com.au/ http://www.smsonline.com.au/ -- Regards, Scott Barnes http://www.mossyblog.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~--- inline: email.jpginline: web.jpginline: smsonline.gifinline: mobile.jpginline: threesquares.gifinline: novahost.gifinline: inevativeLogo_small.jpginline: phone.jpg
[cfaussie] Re: MSSQL 2005 Developer Edition
Scott, You might be the man to pass on a suggestion for the next version off MS SQL. One of the things that has annoyed me the most, is remote database backups? Why is it not easy to do, and when transferring data remotely to local you are not 100% guaranteed the data is exact. I find this very frustrating with the product, I have found that even dropping the tables and copying the data is annoyingly broken. Maybe I am dumb towards the product, but there seems to be a hell of a lot of features gone in EM. I love mySQL Administrator because I can backup and restore a schema remotely from/to my HD locally. Would be so nice to see these enhancements very soon as a Service Pack or something. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Barnes Sent: Monday, 24 September 2007 3:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: MSSQL 2005 Developer Edition You can get it in two editions, Express and obviously with the enterprise edition. That being said, you can manage the basics of a SQL 2005 server with the Studio Express edition... --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---