[cfaussie] Re: Cfflush question

[Andrew Scott]

Chris that will not matter, all that is going to do is run the template
twice.



Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273



-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Chris Velevitch
Sent: Tuesday, 25 September 2007 4:19 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Cfflush question


Is the  new to the page?

Try:-

 



Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au



--~--~-~--~~~---~--~~
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: Cfflush question

[Chris Velevitch]

Is the  new to the page?

Try:-

 



Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au

--~--~-~--~~~---~--~~
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: Connection Pooling

[silverbeetle]

Hey Steve! Long time no speak, hope all is well...

We're averaging about 320,000 hits a day.

We had 537,928 hits yesterday :O


On Sep 25, 2:54 pm, "Steve Onnis" <[EMAIL PROTECTED]> wrote:
> Out of curiosity chris , how many hits do you get a day?
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
>
> Of silverbeetle
> Sent: Tuesday, 25 September 2007 2:49 PM
> To: cfaussie
> Subject: [cfaussie] Re: Connection Pooling
>
> big thanks to charlie for that info. i didnt have much luck on google when
> searching for info on this either.
>
> huge thanks to sean for really giving my problem some attention. best
> service i've had from an isp to date! Looking forward to seeing what
> improvements i can make at my end (stored procedures) and see how the
> changes you've made effect the problem.
>
> On Sep 25, 10:26 am, Sean Bucklar <[EMAIL PROTECTED]> wrote:
> > Charlie Arehart (lists account) wrote:> OK, here's the longer note with
> some thoughts.
> > > First, as for their recommendation to "revise your code and ensure
> > > that you are utilising connection pooling", it could be that your
> > > host is more familiar with .NET, Java, or other languages where one
> > > does indeed control pooling manually (in code).
>
> > The auto-message that Charlie received was drafted at a point in time
> > when the majority of our user base were using ASP (mostly VBSCRIPT)
> > and one of our more common code related issues was a failure to close
> > database connections in code. Managing a very diverse environment we
> > try and keep our alert notices universally applicable where possible.>
> > But there are indeed settings in the CF Admin that can affect this. No
> > one
> > > has mentioned, but what are your settings related to connections for
> > > the DSNs in question? First and foremost, what about "maintain
> > > connections"? Do you have that enabled? If not, then you would
> > > indeed use more connections than needed. I do realize some argue
> > > against enabling it--but that will cause higher connection use and
> prevent pool reuse.
>
> > Mostly in case Chris was wondering, it is enabled. We enable it by
> > default when we create a cfdsn unless specifically asked not to -
> > largely to cut down on excessive connection consumption.
>
> > > It's the DSN connection setting for "limit connections" which, along
> > > with its "restrict connections to" value. That would seem just the
> > > solution here to restrict how many you create. Still, I saw Sean's
> > > later note that this is a rather high-volume site, so you will want
> > > to be careful in evaluating (and
> > > understanding) the impact of any such changes. You seem to be asking
> > > for ideas, though, which is why I write.
>
> > > Steven Erat of Adobe did a nice blog entry on this, including some
> > > case examples and recommendations, back in 2005 at:
>
> > >http://www.talkingtree.com/blog/index.cfm/2005/3/14/ConnPooling1
>
> > That blog entry is lovely. There's been some dispute around the office
> > on exactly what happens when the limit to N connections option is
> > enabled and the N threshold is exceeded. Experimenting on Chris's v.
> > popular production site seeming like a bad idea, building a test app
> > was on my short list for today but that blog entry has saved me the
> effort.
> > Having just had a chat to Chris, we've enabled that setting as it will
> > in the very least reduce the quantity of errors.
>
> > > You had mentioned in an earlier note that you "might hit up the host
> > > for more info and check they have their CF Admin settings correct."
> > > Let's hear what you have.
>
> > Select method - Direct
> > Limit connections - Restrict connections to 35 (previously wasn't
> > configured)
> > Maintain Connections
> > Max pooled statements 1000
> > Timeout 20 Interval 7
> > Login timeout 45 (previously 30)
>
> > My current plan is to tune to timeout and interval settings down if
> > the errors persist further. I don't think that the application is
> > currently exceeding the Max pooled statements - but I don't have any
> > aversion to growing that value either.> If it's just that your site is
> > a higher volume CF site than your host is
> > > used to, and none of the above help, then perhaps there's nothing to
> > > be done other than to negotiate with them to let you use more
> > > connections, or change plans, or change hosts.
>
> > A plan change is certainly possible. Chris is already using the
> > packages at the top of our shared platform offerings, the next step up
> > being a dedicated SQL instance. I'm sure he'd rather get more out of
> > what he's already paying for then pay us some more money. While it's
> > certainly an available option - we're more then happy to try and get
> > him the most out of what he's already got.> Hope that's helpful to you and
> others.
>
> > It was certainly a big help to me. That blog link in particular is
> > lovely - I failed at Google when I 

[cfaussie] Re: Connection Pooling

[Steve Onnis]

Out of curiosity chris , how many hits do you get a day?

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of silverbeetle
Sent: Tuesday, 25 September 2007 2:49 PM
To: cfaussie
Subject: [cfaussie] Re: Connection Pooling


big thanks to charlie for that info. i didnt have much luck on google when
searching for info on this either.

huge thanks to sean for really giving my problem some attention. best
service i've had from an isp to date! Looking forward to seeing what
improvements i can make at my end (stored procedures) and see how the
changes you've made effect the problem.

On Sep 25, 10:26 am, Sean Bucklar <[EMAIL PROTECTED]> wrote:
> Charlie Arehart (lists account) wrote:> OK, here's the longer note with
some thoughts.
> > First, as for their recommendation to "revise your code and ensure 
> > that you are utilising connection pooling", it could be that your 
> > host is more familiar with .NET, Java, or other languages where one 
> > does indeed control pooling manually (in code).
>
> The auto-message that Charlie received was drafted at a point in time 
> when the majority of our user base were using ASP (mostly VBSCRIPT) 
> and one of our more common code related issues was a failure to close 
> database connections in code. Managing a very diverse environment we 
> try and keep our alert notices universally applicable where possible.> 
> But there are indeed settings in the CF Admin that can affect this. No 
> one
> > has mentioned, but what are your settings related to connections for 
> > the DSNs in question? First and foremost, what about "maintain 
> > connections"? Do you have that enabled? If not, then you would 
> > indeed use more connections than needed. I do realize some argue 
> > against enabling it--but that will cause higher connection use and
prevent pool reuse.
>
> Mostly in case Chris was wondering, it is enabled. We enable it by 
> default when we create a cfdsn unless specifically asked not to - 
> largely to cut down on excessive connection consumption.
>
> > It's the DSN connection setting for "limit connections" which, along 
> > with its "restrict connections to" value. That would seem just the 
> > solution here to restrict how many you create. Still, I saw Sean's 
> > later note that this is a rather high-volume site, so you will want 
> > to be careful in evaluating (and
> > understanding) the impact of any such changes. You seem to be asking 
> > for ideas, though, which is why I write.
>
> > Steven Erat of Adobe did a nice blog entry on this, including some 
> > case examples and recommendations, back in 2005 at:
>
> >http://www.talkingtree.com/blog/index.cfm/2005/3/14/ConnPooling1
>
> That blog entry is lovely. There's been some dispute around the office 
> on exactly what happens when the limit to N connections option is 
> enabled and the N threshold is exceeded. Experimenting on Chris's v.
> popular production site seeming like a bad idea, building a test app 
> was on my short list for today but that blog entry has saved me the
effort.
> Having just had a chat to Chris, we've enabled that setting as it will 
> in the very least reduce the quantity of errors.
>
> > You had mentioned in an earlier note that you "might hit up the host 
> > for more info and check they have their CF Admin settings correct."  
> > Let's hear what you have.
>
> Select method - Direct
> Limit connections - Restrict connections to 35 (previously wasn't
> configured)
> Maintain Connections
> Max pooled statements 1000
> Timeout 20 Interval 7
> Login timeout 45 (previously 30)
>
> My current plan is to tune to timeout and interval settings down if 
> the errors persist further. I don't think that the application is 
> currently exceeding the Max pooled statements - but I don't have any 
> aversion to growing that value either.> If it's just that your site is 
> a higher volume CF site than your host is
> > used to, and none of the above help, then perhaps there's nothing to 
> > be done other than to negotiate with them to let you use more 
> > connections, or change plans, or change hosts.
>
> A plan change is certainly possible. Chris is already using the 
> packages at the top of our shared platform offerings, the next step up 
> being a dedicated SQL instance. I'm sure he'd rather get more out of 
> what he's already paying for then pay us some more money. While it's 
> certainly an available option - we're more then happy to try and get 
> him the most out of what he's already got.> Hope that's helpful to you and
others.
>
> It was certainly a big help to me. That blog link in particular is 
> lovely - I failed at Google when I tried to find something of that 
> nature yesterday.






--~--~-~--~~~---~--~~
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 [EM

[cfaussie] Re: Connection Pooling

[silverbeetle]

big thanks to charlie for that info. i didnt have much luck on google
when searching for info on this either.

huge thanks to sean for really giving my problem some attention. best
service i've had from an isp to date! Looking forward to seeing what
improvements i can make at my end (stored procedures) and see how the
changes you've made effect the problem.

On Sep 25, 10:26 am, Sean Bucklar <[EMAIL PROTECTED]> wrote:
> Charlie Arehart (lists account) wrote:> OK, here's the longer note with some 
> thoughts.
> > First, as for their recommendation to "revise your code and ensure that you
> > are utilising connection pooling", it could be that your host is more
> > familiar with .NET, Java, or other languages where one does indeed control
> > pooling manually (in code).
>
> The auto-message that Charlie received was drafted at a point in time
> when the majority of our user base were using ASP (mostly VBSCRIPT) and
> one of our more common code related issues was a failure to close
> database connections in code. Managing a very diverse environment we try
> and keep our alert notices universally applicable where possible.> But there 
> are indeed settings in the CF Admin that can affect this. No one
> > has mentioned, but what are your settings related to connections for the
> > DSNs in question? First and foremost, what about "maintain connections"? Do
> > you have that enabled? If not, then you would indeed use more connections
> > than needed. I do realize some argue against enabling it--but that will
> > cause higher connection use and prevent pool reuse.
>
> Mostly in case Chris was wondering, it is enabled. We enable it by
> default when we create a cfdsn unless specifically asked not to -
> largely to cut down on excessive connection consumption.
>
> > It's the DSN connection setting for "limit connections" which, along with
> > its "restrict connections to" value. That would seem just the solution here
> > to restrict how many you create. Still, I saw Sean's later note that this is
> > a rather high-volume site, so you will want to be careful in evaluating (and
> > understanding) the impact of any such changes. You seem to be asking for
> > ideas, though, which is why I write.
>
> > Steven Erat of Adobe did a nice blog entry on this, including some case
> > examples and recommendations, back in 2005 at:
>
> >http://www.talkingtree.com/blog/index.cfm/2005/3/14/ConnPooling1
>
> That blog entry is lovely. There's been some dispute around the office
> on exactly what happens when the limit to N connections option is
> enabled and the N threshold is exceeded. Experimenting on Chris's v.
> popular production site seeming like a bad idea, building a test app was
> on my short list for today but that blog entry has saved me the effort.
> Having just had a chat to Chris, we've enabled that setting as it will
> in the very least reduce the quantity of errors.
>
> > You had mentioned in an earlier note that you "might hit up the host for
> > more info and check they have their CF Admin settings correct."  Let's hear
> > what you have.
>
> Select method - Direct
> Limit connections - Restrict connections to 35 (previously wasn't
> configured)
> Maintain Connections
> Max pooled statements 1000
> Timeout 20 Interval 7
> Login timeout 45 (previously 30)
>
> My current plan is to tune to timeout and interval settings down if the
> errors persist further. I don't think that the application is currently
> exceeding the Max pooled statements - but I don't have any aversion to
> growing that value either.> If it's just that your site is a higher volume CF 
> site than your host is
> > used to, and none of the above help, then perhaps there's nothing to be done
> > other than to negotiate with them to let you use more connections, or change
> > plans, or change hosts.
>
> A plan change is certainly possible. Chris is already using the packages
> at the top of our shared platform offerings, the next step up being a
> dedicated SQL instance. I'm sure he'd rather get more out of what he's
> already paying for then pay us some more money. While it's certainly an
> available option - we're more then happy to try and get him the most out
> of what he's already got.> Hope that's helpful to you and others.
>
> It was certainly a big help to me. That blog link in particular is
> lovely - I failed at Google when I tried to find something of that
> nature yesterday.


--~--~-~--~~~---~--~~
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: Can you run this CF8 Code

[Andrew Scott]

Yeah its possible.

 

The only reason I brought it up, because the documentation says you can do
this.

 



 

Yet I tried it your way first, no problem. Yet tried the example in the
documentation and got the same assembly error that has been discussed here.

 

Go figure.

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 12:36 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

Andrew,

 

Thanks for trying it anyway, this problem has been on going for weeks on
cf-talk.

 

I think I'll blog it to save others. I wondered if I installed CF before the
.NET framework, can't remember.

 

Regards

Dale Fraser

 

http://learncf.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
-~--~~~~--~~--~--~---

[cfaussie] Re: Can you run this CF8 Code

[Dale Fraser]

Andrew,

 

Thanks for trying it anyway, this problem has been on going for weeks on
cf-talk.

 

I think I'll blog it to save others. I wondered if I installed CF before the
.NET framework, can't remember.

 

Regards

Dale Fraser

 

http://learncf.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Tuesday, 25 September 2007 10:59 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

Btw it might be worth noting that your example works on .Net V2 so if you
have Vista installed which uses .Net V3.0 and doesn't have the assemblies
for V2 installed it will be a problem as well.

 

The reason I bring this up is that the assembly is not required (I believe)
because there is an assembly list in the config files that is a search path
for assemblies and it might be extremely possible that these are not being
setup when the .Net bridge is installed.

 

Not sure if this helps others or notJ

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 10:45 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

I finally! Found this problem.

 

I had to uninstall it .NET bit (yes it has its own uninstaller)

 

And reinstall it (yes it has its own installer) can download from adobe
site.

 

Choose integrated to CF on install. Even though my dotneterror.log only had
successes on install, obviously something didn't work.

 

Regards

Dale Fraser

 

http://learncf.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Tuesday, 25 September 2007 10:29 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

Works for me?

 

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 10:20 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Can you run this CF8 Code

 

Almost at the end of the road with this,

 

Asking people with CF8 on Windows to try the code to see if it works for
them, doesn't work for me.

 

Can't call any .NET DLL, calling the framework Classes does however work.

 





 

Regards

Dale Fraser

 

http://learncf.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
-~--~~~~--~~--~--~---

[cfaussie] Re: Can you run this CF8 Code

[Andrew Scott]

Btw it might be worth noting that your example works on .Net V2 so if you
have Vista installed which uses .Net V3.0 and doesn't have the assemblies
for V2 installed it will be a problem as well.

 

The reason I bring this up is that the assembly is not required (I believe)
because there is an assembly list in the config files that is a search path
for assemblies and it might be extremely possible that these are not being
setup when the .Net bridge is installed.

 

Not sure if this helps others or notJ

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 10:45 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

I finally! Found this problem.

 

I had to uninstall it .NET bit (yes it has its own uninstaller)

 

And reinstall it (yes it has its own installer) can download from adobe
site.

 

Choose integrated to CF on install. Even though my dotneterror.log only had
successes on install, obviously something didn't work.

 

Regards

Dale Fraser

 

http://learncf.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Tuesday, 25 September 2007 10:29 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

Works for me?

 

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 10:20 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Can you run this CF8 Code

 

Almost at the end of the road with this,

 

Asking people with CF8 on Windows to try the code to see if it works for
them, doesn't work for me.

 

Can't call any .NET DLL, calling the framework Classes does however work.

 





 

Regards

Dale Fraser

 

http://learncf.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
-~--~~~~--~~--~--~---

[cfaussie] Re: Can you run this CF8 Code

[Dale Fraser]

I finally! Found this problem.

 

I had to uninstall it .NET bit (yes it has its own uninstaller)

 

And reinstall it (yes it has its own installer) can download from adobe
site.

 

Choose integrated to CF on install. Even though my dotneterror.log only had
successes on install, obviously something didn't work.

 

Regards

Dale Fraser

 

http://learncf.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Tuesday, 25 September 2007 10:29 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Can you run this CF8 Code

 

Works for me?

 

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 10:20 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Can you run this CF8 Code

 

Almost at the end of the road with this,

 

Asking people with CF8 on Windows to try the code to see if it works for
them, doesn't work for me.

 

Can't call any .NET DLL, calling the framework Classes does however work.

 





 

Regards

Dale Fraser

 

http://learncf.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
-~--~~~~--~~--~--~---

[cfaussie] Re: Can you run this CF8 Code

[Andrew Scott]

Works for me?

 

 



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 Dale Fraser
Sent: Tuesday, 25 September 2007 10:20 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Can you run this CF8 Code

 

Almost at the end of the road with this,

 

Asking people with CF8 on Windows to try the code to see if it works for
them, doesn't work for me.

 

Can't call any .NET DLL, calling the framework Classes does however work.

 





 

Regards

Dale Fraser

 

http://learncf.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
-~--~~~~--~~--~--~---

[cfaussie] Re: Connection Pooling

[Sean Bucklar]

Charlie Arehart (lists account) wrote:
> OK, here's the longer note with some thoughts. 
> First, as for their recommendation to "revise your code and ensure that you
> are utilising connection pooling", it could be that your host is more
> familiar with .NET, Java, or other languages where one does indeed control
> pooling manually (in code). 
>   
The auto-message that Charlie received was drafted at a point in time 
when the majority of our user base were using ASP (mostly VBSCRIPT) and 
one of our more common code related issues was a failure to close 
database connections in code. Managing a very diverse environment we try 
and keep our alert notices universally applicable where possible.
> But there are indeed settings in the CF Admin that can affect this. No one
> has mentioned, but what are your settings related to connections for the
> DSNs in question? First and foremost, what about "maintain connections"? Do
> you have that enabled? If not, then you would indeed use more connections
> than needed. I do realize some argue against enabling it--but that will
> cause higher connection use and prevent pool reuse. 
>   
Mostly in case Chris was wondering, it is enabled. We enable it by 
default when we create a cfdsn unless specifically asked not to - 
largely to cut down on excessive connection consumption.

> It's the DSN connection setting for "limit connections" which, along with
> its "restrict connections to" value. That would seem just the solution here
> to restrict how many you create. Still, I saw Sean's later note that this is
> a rather high-volume site, so you will want to be careful in evaluating (and
> understanding) the impact of any such changes. You seem to be asking for
> ideas, though, which is why I write.
>
> Steven Erat of Adobe did a nice blog entry on this, including some case
> examples and recommendations, back in 2005 at:
>
> http://www.talkingtree.com/blog/index.cfm/2005/3/14/ConnPooling1
>
>   
That blog entry is lovely. There's been some dispute around the office 
on exactly what happens when the limit to N connections option is 
enabled and the N threshold is exceeded. Experimenting on Chris's v. 
popular production site seeming like a bad idea, building a test app was 
on my short list for today but that blog entry has saved me the effort. 
Having just had a chat to Chris, we've enabled that setting as it will 
in the very least reduce the quantity of errors.

> You had mentioned in an earlier note that you "might hit up the host for
> more info and check they have their CF Admin settings correct."  Let's hear
> what you have.
>   
Select method - Direct
Limit connections - Restrict connections to 35 (previously wasn't 
configured)
Maintain Connections
Max pooled statements 1000
Timeout 20 Interval 7
Login timeout 45 (previously 30)

My current plan is to tune to timeout and interval settings down if the 
errors persist further. I don't think that the application is currently 
exceeding the Max pooled statements - but I don't have any aversion to 
growing that value either.
> If it's just that your site is a higher volume CF site than your host is
> used to, and none of the above help, then perhaps there's nothing to be done
> other than to negotiate with them to let you use more connections, or change
> plans, or change hosts.
>   
A plan change is certainly possible. Chris is already using the packages 
at the top of our shared platform offerings, the next step up being a 
dedicated SQL instance. I'm sure he'd rather get more out of what he's 
already paying for then pay us some more money. While it's certainly an 
available option - we're more then happy to try and get him the most out 
of what he's already got.
> Hope that's helpful to you and others.
>   
It was certainly a big help to me. That blog link in particular is 
lovely - I failed at Google when I tried to find something of that 
nature yesterday.

--~--~-~--~~~---~--~~
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] Can you run this CF8 Code

[Dale Fraser]

Almost at the end of the road with this,

 

Asking people with CF8 on Windows to try the code to see if it works for
them, doesn't work for me.

 

Can't call any .NET DLL, calling the framework Classes does however work.

 





 

Regards

Dale Fraser

 

http://learncf.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
-~--~~~~--~~--~--~---

[cfaussie] Re: Cfflush question

[Andrew Scott]

Scott,

The short answer is not 100% sure, but if it is as you described then I
believe you have found a bug.



Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273



-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Tuesday, 25 September 2007 9:22 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Cfflush question


Hi,

I have been using CFFlush for a while now to give the user some output for a
long running page.

However, I started getting the error:

 Unable to perform CFFLUSH. You have called CFFLUSH in an invalid location,
such as inside a CFQUERY or between a CFML custom tag start and end tag.
The error occurred on line 

Problem is, there is no CFFLUSH between any tags or within a cfquery. I have
recently re-written the page and double checked this.

I have noticed that if I have the following code structure:


...
cfflush



cfflush

the following call to second cfflush will fail, however if I comment out the
call to the UDF out, the cfflush works as expected.

Inside the user definined function there are NO CFFLUSH's but there are
CFSILENT tags.

If I remove the CFSILENT tags, the CFFLUSH's work. So I have removed the
CFSILENT's fom inside the UDF, but I was wondering why this might be?

CFMX 6.1








--~--~-~--~~~---~--~~
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] Cfflush question

[Scott Thornton]

Hi,

I have been using CFFlush for a while now to give the user some output for a 
long running page.

However, I started getting the error:

 Unable to perform CFFLUSH. You have called CFFLUSH in an invalid location, 
such as inside a CFQUERY or between a CFML custom tag start and end tag. 
The error occurred on line 

Problem is, there is no CFFLUSH between any tags or within a cfquery. I have 
recently re-written the page and double checked this.

I have noticed that if I have the following code structure:


...
cfflush



cfflush

the following call to second cfflush will fail, however if I comment out the 
call to the UDF out, the cfflush works as expected.

Inside the user definined function there are NO CFFLUSH's but there are 
CFSILENT tags.

If I remove the CFSILENT tags, the CFFLUSH's work. So I have removed the 
CFSILENT's fom inside the UDF, but I was wondering why this might be?

CFMX 6.1






--~--~-~--~~~---~--~~
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

[Andrew Scott]

Ryan,

Cheers but we own Red-Gate SQL Bundle becuase of those exact
limitations in MS SQL 2005.


On 9/25/07, Ryan Sabir <[EMAIL PROTECTED]> wrote:
>
> Heya Andrew,
>
> We've been having so many problems with transferring data between SQL 2005 
> DBs that we are using this tool these days:
>
> http://www.topshareware.com/SQL-Dumper-download-42374.htm
>
> SQL Dumper. It converts your whole database to a series of INSERT statements 
> so you can easily recreate your data remotely.
>
> seeya
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew 
> Scott
> Sent: Monday, 24 September 2007 9:52 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> yes I do have a soft spot for MS SQL, but we are begining to use mySQL
> even more these days.
>
> Derby, I think it is still to young at the moment and needs to
> implement some very basic things like top and offset and a whole heap
> of other things. But will be keeping an eye on its progress that is
> for sure.
>
> As for the original question, MS haven't given to much thought to
> smaller situations like getting the DTS to work properly as I have had
> it fail so many times on the most basic things, and the fact that
> backing up a DB on a shared DB server is right pain in the arse.
>
>
> On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> > Indeed. I think it's a good product, but for commercial use I think MS SQL
> > or Oracle are pretty standard these days.
> >
> > While MySQL is getting better, MS SQL is also, MS SQL Express is now around
> > and I find myself using it for anything I need that's free, then when I want
> > to go main stream, i'ts off to MS SQL.
> >
> > I think you might find Andrew prefers MS SQL also, if he wasn't using it, he
> > wouldn't have the question.
> >
> > Mind you, I have a soft spot for Apache Derby.
> >
> > Regards
> > Dale Fraser
> >
> > http://learncf.com
> >
> >
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 9:05 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> > Yes wars start this way :-)
> >
> >
> > On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
> > >
> > > You are playing with fire with a comment like that Dale.  I am sure that a
> > > lot of people on this list and others would disagree with you saying that
> > > mySQL is a toy.  Feature wise it is getting up there. From my experience
> > it
> > > is certainly up there in relation to speed and it has a few nice features
> > > that MSSQL doesn't have.
> > >
> > > -Original Message-
> > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> > Behalf
> > > Of Dale Fraser
> > > Sent: Monday, 24 September 2007 8:45 PM
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > >
> > > I understand why you would like it.
> > >
> > > But MySQL is a toy and it makes sense
> > >
> > > MSSQL is for large databases, I don't see how this would work to backup
> > > gig's of database to some remote disk. In fact I can't see it working very
> > > well on any database of any reasonable size.
> > >
> > > Regards
> > > Dale Fraser
> > >
> > > http://learncf.com
> > >
> > > -Original Message-
> > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> > Behalf
> > > Of Andrew Scott
> > > Sent: Monday, 24 September 2007 5:55 PM
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > >
> > > Nice if you have full access to the server?
> > >
> > > But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
> > > databases and the MS one I have to get them to back up and place in my ftp
> > > for me to download. With the mySQL ones I backup to my desktop and have no
> > > hassles restoring to a database server here, with no interaction with
> > > support.
> > >
> > > Are you seeing the point now?
> > >
> > >
> > > On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> > > >
> > > >
> > > >
> > > > Backup
> > > >
> > > >
> > > >
> > > > Ftp
> > > >
> > > >
> > > >
> > > >
> > > > Regards
> > > >
> > > > Dale Fraser
> > > >
> > > >
> > > >
> > > > http://learncf.com
> > > >
> > > >
> > > >
> > > >
> > > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> > > Behalf
> > > > Of Andrew Scott
> > > > Sent: Monday, 24 September 2007 4:44 PM
> > > >
> > > > To: cfaussie@googlegroups.com
> > > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > > >
> > > > To: cfaussie@googlegroups.com
> > > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Scott,
> > > >
> > > >
> > > >
> > > > How does that help me, backup a database remotely to my local machine?
> > > > The only options are to the servers hard drive, or tape?
> > > >
> > > >

[cfaussie] Re: MSSQL 2005 Developer Edition

[Ryan Sabir]

Heya Andrew,

We've been having so many problems with transferring data between SQL 2005 DBs 
that we are using this tool these days: 

http://www.topshareware.com/SQL-Dumper-download-42374.htm

SQL Dumper. It converts your whole database to a series of INSERT statements so 
you can easily recreate your data remotely.

seeya


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew 
Scott
Sent: Monday, 24 September 2007 9:52 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition


yes I do have a soft spot for MS SQL, but we are begining to use mySQL
even more these days.

Derby, I think it is still to young at the moment and needs to
implement some very basic things like top and offset and a whole heap
of other things. But will be keeping an eye on its progress that is
for sure.

As for the original question, MS haven't given to much thought to
smaller situations like getting the DTS to work properly as I have had
it fail so many times on the most basic things, and the fact that
backing up a DB on a shared DB server is right pain in the arse.


On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> Indeed. I think it's a good product, but for commercial use I think MS SQL
> or Oracle are pretty standard these days.
>
> While MySQL is getting better, MS SQL is also, MS SQL Express is now around
> and I find myself using it for anything I need that's free, then when I want
> to go main stream, i'ts off to MS SQL.
>
> I think you might find Andrew prefers MS SQL also, if he wasn't using it, he
> wouldn't have the question.
>
> Mind you, I have a soft spot for Apache Derby.
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 9:05 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> Yes wars start this way :-)
>
>
> On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
> >
> > You are playing with fire with a comment like that Dale.  I am sure that a
> > lot of people on this list and others would disagree with you saying that
> > mySQL is a toy.  Feature wise it is getting up there. From my experience
> it
> > is certainly up there in relation to speed and it has a few nice features
> > that MSSQL doesn't have.
> >
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Dale Fraser
> > Sent: Monday, 24 September 2007 8:45 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> > I understand why you would like it.
> >
> > But MySQL is a toy and it makes sense
> >
> > MSSQL is for large databases, I don't see how this would work to backup
> > gig's of database to some remote disk. In fact I can't see it working very
> > well on any database of any reasonable size.
> >
> > Regards
> > Dale Fraser
> >
> > http://learncf.com
> >
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 5:55 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> > Nice if you have full access to the server?
> >
> > But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
> > databases and the MS one I have to get them to back up and place in my ftp
> > for me to download. With the mySQL ones I backup to my desktop and have no
> > hassles restoring to a database server here, with no interaction with
> > support.
> >
> > Are you seeing the point now?
> >
> >
> > On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > >
> > > Backup
> > >
> > >
> > >
> > > Ftp
> > >
> > >
> > >
> > >
> > > Regards
> > >
> > > Dale Fraser
> > >
> > >
> > >
> > > http://learncf.com
> > >
> > >
> > >
> > >
> > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> > Behalf
> > > Of Andrew Scott
> > > Sent: Monday, 24 September 2007 4:44 PM
> > >
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > >
> > >
> > >
> > >
> > > Scott,
> > >
> > >
> > >
> > > How does that help me, backup a database remotely to my local machine?
> > > The only options are to the servers hard drive, or tape?
> > >
> > >
> > >
> > > 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 4:18 PM
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > >
> > >
> > >
>

[cfaussie] Re: Connection Pooling

[Charlie Arehart \(lists account\)]

OK, here's the longer note with some thoughts. 

Executive summary
It may be that you're dealing with a host who simply doesn't
understand CF very well, so their recommendation to look at your code
regarding connections may be dodgy. 
But there are indeed settings in the CF Admin that could be
affecting this, which haven't been discussed in this thread yet. Also, if
you use USERNAME/PASSWORD attributes in CFQUERY, that could affect pool
reuse (and from that standpoint, then, they could be right in their
recommendation).

First, as for their recommendation to "revise your code and ensure that you
are utilising connection pooling", it could be that your host is more
familiar with .NET, Java, or other languages where one does indeed control
pooling manually (in code). As has been said, though, in CFML we do not
typically and instead rely on the engine to do it, as per our Admin console
settings for the DSN. (Only rarely might one bother to manipulate the
pooling process in CFML code.)

But there are indeed settings in the CF Admin that can affect this. No one
has mentioned, but what are your settings related to connections for the
DSNs in question? First and foremost, what about "maintain connections"? Do
you have that enabled? If not, then you would indeed use more connections
than needed. I do realize some argue against enabling it--but that will
cause higher connection use and prevent pool reuse. 

Perhaps you have enabled that setting: how might one generate a lot of
connections even so? Well, do you use the username and password attributes
on CFQUERY? If so, that would prevent reuse of a connection by someone using
a different username/password. If you had no choice in that matter, there is
another setting to limit how many connections you do create.

In fact, even if you don't use per-user authentication of CFQUERY, that
setting could help you. 

It's the DSN connection setting for "limit connections" which, along with
its "restrict connections to" value. That would seem just the solution here
to restrict how many you create. Still, I saw Sean's later note that this is
a rather high-volume site, so you will want to be careful in evaluating (and
understanding) the impact of any such changes. You seem to be asking for
ideas, though, which is why I write.

Steven Erat of Adobe did a nice blog entry on this, including some case
examples and recommendations, back in 2005 at:

http://www.talkingtree.com/blog/index.cfm/2005/3/14/ConnPooling1

Note also that there are two other DSN settings related to connections:
"timeout" and "interval" options (as opposed to "login timeout"). Perhaps
those need to be tweaked.

Finally, take note if you may have any values in the connection string which
might have an impact on connection pooling? There are some.

You had mentioned in an earlier note that you "might hit up the host for
more info and check they have their CF Admin settings correct."  Let's hear
what you have.

If it's just that your site is a higher volume CF site than your host is
used to, and none of the above help, then perhaps there's nothing to be done
other than to negotiate with them to let you use more connections, or change
plans, or change hosts.

Hope that's helpful to you and others.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of silverbeetle
Sent: Sunday, September 23, 2007 7:46 PM
To: cfaussie
Subject: [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] Re: Connection Pooling

[Charlie Arehart \(lists account\)]

On this matter of connection pooling, and the assertion by your host, Chris,
that you're using too many of them, I've got a couple of thoughts.
Unfortunately, it will take a rather lengthy note to reply.

Since some don't like long notes and won't even start to read them, I wanted
to offer this note of advanced warning. :-) 

If you're at all interested in the topic, though, I hope you'll read along,
since I make some points it doesn't seem anyone else has yet. Hope it's
useful.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of silverbeetle
Sent: Sunday, September 23, 2007 7:46 PM
To: cfaussie
Subject: [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] Re: MSSQL 2005 Developer Edition

[Andrew Scott]

yes I do have a soft spot for MS SQL, but we are begining to use mySQL
even more these days.

Derby, I think it is still to young at the moment and needs to
implement some very basic things like top and offset and a whole heap
of other things. But will be keeping an eye on its progress that is
for sure.

As for the original question, MS haven't given to much thought to
smaller situations like getting the DTS to work properly as I have had
it fail so many times on the most basic things, and the fact that
backing up a DB on a shared DB server is right pain in the arse.


On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> Indeed. I think it's a good product, but for commercial use I think MS SQL
> or Oracle are pretty standard these days.
>
> While MySQL is getting better, MS SQL is also, MS SQL Express is now around
> and I find myself using it for anything I need that's free, then when I want
> to go main stream, i'ts off to MS SQL.
>
> I think you might find Andrew prefers MS SQL also, if he wasn't using it, he
> wouldn't have the question.
>
> Mind you, I have a soft spot for Apache Derby.
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 9:05 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> Yes wars start this way :-)
>
>
> On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
> >
> > You are playing with fire with a comment like that Dale.  I am sure that a
> > lot of people on this list and others would disagree with you saying that
> > mySQL is a toy.  Feature wise it is getting up there. From my experience
> it
> > is certainly up there in relation to speed and it has a few nice features
> > that MSSQL doesn't have.
> >
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Dale Fraser
> > Sent: Monday, 24 September 2007 8:45 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> > I understand why you would like it.
> >
> > But MySQL is a toy and it makes sense
> >
> > MSSQL is for large databases, I don't see how this would work to backup
> > gig's of database to some remote disk. In fact I can't see it working very
> > well on any database of any reasonable size.
> >
> > Regards
> > Dale Fraser
> >
> > http://learncf.com
> >
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 5:55 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> > Nice if you have full access to the server?
> >
> > But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
> > databases and the MS one I have to get them to back up and place in my ftp
> > for me to download. With the mySQL ones I backup to my desktop and have no
> > hassles restoring to a database server here, with no interaction with
> > support.
> >
> > Are you seeing the point now?
> >
> >
> > On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > >
> > > Backup
> > >
> > >
> > >
> > > Ftp
> > >
> > >
> > >
> > >
> > > Regards
> > >
> > > Dale Fraser
> > >
> > >
> > >
> > > http://learncf.com
> > >
> > >
> > >
> > >
> > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> > Behalf
> > > Of Andrew Scott
> > > Sent: Monday, 24 September 2007 4:44 PM
> > >
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > >
> > >
> > >
> > >
> > > Scott,
> > >
> > >
> > >
> > > How does that help me, backup a database remotely to my local machine?
> > > The only options are to the servers hard drive, or tape?
> > >
> > >
> > >
> > > 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 4:18 PM
> > > To: cfaussie@googlegroups.com
> > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> > >
> > >
> > >
> > >
> > > Umm Define easy?
> > >
> > >
> > >
> > >
> > >
> > > eg:
> > > http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > > 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 dat

[cfaussie] Re: MSSQL 2005 Developer Edition

[Dale Fraser]

Indeed. I think it's a good product, but for commercial use I think MS SQL
or Oracle are pretty standard these days.

While MySQL is getting better, MS SQL is also, MS SQL Express is now around
and I find myself using it for anything I need that's free, then when I want
to go main stream, i'ts off to MS SQL.

I think you might find Andrew prefers MS SQL also, if he wasn't using it, he
wouldn't have the question.

Mind you, I have a soft spot for Apache Derby.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, 24 September 2007 9:05 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition


Yes wars start this way :-)


On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> You are playing with fire with a comment like that Dale.  I am sure that a
> lot of people on this list and others would disagree with you saying that
> mySQL is a toy.  Feature wise it is getting up there. From my experience
it
> is certainly up there in relation to speed and it has a few nice features
> that MSSQL doesn't have.
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
> Of Dale Fraser
> Sent: Monday, 24 September 2007 8:45 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> I understand why you would like it.
>
> But MySQL is a toy and it makes sense
>
> MSSQL is for large databases, I don't see how this would work to backup
> gig's of database to some remote disk. In fact I can't see it working very
> well on any database of any reasonable size.
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 5:55 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> Nice if you have full access to the server?
>
> But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
> databases and the MS one I have to get them to back up and place in my ftp
> for me to download. With the mySQL ones I backup to my desktop and have no
> hassles restoring to a database server here, with no interaction with
> support.
>
> Are you seeing the point now?
>
>
> On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Backup
> >
> >
> >
> > Ftp
> >
> >
> >
> >
> > Regards
> >
> > Dale Fraser
> >
> >
> >
> > http://learncf.com
> >
> >
> >
> >
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 4:44 PM
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> >
> > Scott,
> >
> >
> >
> > How does that help me, backup a database remotely to my local machine?
> > The only options are to the servers hard drive, or tape?
> >
> >
> >
> > 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 4:18 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> > Umm Define easy?
> >
> >
> >
> >
> >
> > eg:
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
> >
> >
> > 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
> >
> >
> >
> >
> > 

[cfaussie] Re: MSSQL 2005 Developer Edition

[Steve Onnis]

We are going to invade Iran to look for databases of mass transactions? 

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, 24 September 2007 9:05 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition


Yes wars start this way :-)


On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> You are playing with fire with a comment like that Dale.  I am sure 
> that a lot of people on this list and others would disagree with you 
> saying that mySQL is a toy.  Feature wise it is getting up there. From 
> my experience it is certainly up there in relation to speed and it has 
> a few nice features that MSSQL doesn't have.
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On 
> Behalf Of Dale Fraser
> Sent: Monday, 24 September 2007 8:45 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> I understand why you would like it.
>
> But MySQL is a toy and it makes sense
>
> MSSQL is for large databases, I don't see how this would work to 
> backup gig's of database to some remote disk. In fact I can't see it 
> working very well on any database of any reasonable size.
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On 
> Behalf Of Andrew Scott
> Sent: Monday, 24 September 2007 5:55 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> Nice if you have full access to the server?
>
> But this is a shared host, and I have 1 MS SQL databases and 2 mySQL 
> databases and the MS one I have to get them to back up and place in my 
> ftp for me to download. With the mySQL ones I backup to my desktop and 
> have no hassles restoring to a database server here, with no 
> interaction with support.
>
> Are you seeing the point now?
>
>
> On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Backup
> >
> >
> >
> > Ftp
> >
> >
> >
> >
> > Regards
> >
> > Dale Fraser
> >
> >
> >
> > http://learncf.com
> >
> >
> >
> >
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] 
> > On
> Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 4:44 PM
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> >
> > Scott,
> >
> >
> >
> > How does that help me, backup a database remotely to my local machine?
> > The only options are to the servers hard drive, or tape?
> >
> >
> >
> > 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 4:18 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> > Umm Define easy?
> >
> >
> >
> >
> >
> > eg:
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
> >
> >
> > 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...
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > >
> >
>
>
> --
>
>
>
> Senior Coldfusion Developer
> Aegeon Pty. Ltd.
> www.aegeon.com.au
> Phone: +613  8676 4223
> Mobile: 0404 998 2

[cfaussie] Re: MSSQL 2005 Developer Edition

[Andrew Scott]

Hmm, I think you will find that mySQL Enterpirse is as good if not
better than MS SQL in my opinion. Not as good as Oracle, but certainly
competes with MS.


On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> I understand why you would like it.
>
> But MySQL is a toy and it makes sense
>
> MSSQL is for large databases, I don't see how this would work to backup
> gig's of database to some remote disk. In fact I can't see it working very
> well on any database of any reasonable size.
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 5:55 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> Nice if you have full access to the server?
>
> But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
> databases and the MS one I have to get them to back up and place in my
> ftp for me to download. With the mySQL ones I backup to my desktop and
> have no hassles restoring to a database server here, with no
> interaction with support.
>
> Are you seeing the point now?
>
>
> On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Backup
> >
> >
> >
> > Ftp
> >
> >
> >
> >
> > Regards
> >
> > Dale Fraser
> >
> >
> >
> > http://learncf.com
> >
> >
> >
> >
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 4:44 PM
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> >
> > Scott,
> >
> >
> >
> > How does that help me, backup a database remotely to my local machine? The
> > only options are to the servers hard drive, or tape?
> >
> >
> >
> > 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 4:18 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> > Umm Define easy?
> >
> >
> >
> >
> >
> > eg:
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
> >
> >
> > 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...
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > >
> >
>
>
> --
>
>
>
> Senior Coldfusion Developer
> Aegeon Pty. Ltd.
> www.aegeon.com.au
> Phone: +613  8676 4223
> Mobile: 0404 998 273
>
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

--~--~-~--~~~---~--~~
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

[Andrew Scott]

Yes wars start this way :-)


On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> You are playing with fire with a comment like that Dale.  I am sure that a
> lot of people on this list and others would disagree with you saying that
> mySQL is a toy.  Feature wise it is getting up there. From my experience it
> is certainly up there in relation to speed and it has a few nice features
> that MSSQL doesn't have.
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Dale Fraser
> Sent: Monday, 24 September 2007 8:45 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> I understand why you would like it.
>
> But MySQL is a toy and it makes sense
>
> MSSQL is for large databases, I don't see how this would work to backup
> gig's of database to some remote disk. In fact I can't see it working very
> well on any database of any reasonable size.
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 5:55 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
> Nice if you have full access to the server?
>
> But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
> databases and the MS one I have to get them to back up and place in my ftp
> for me to download. With the mySQL ones I backup to my desktop and have no
> hassles restoring to a database server here, with no interaction with
> support.
>
> Are you seeing the point now?
>
>
> On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Backup
> >
> >
> >
> > Ftp
> >
> >
> >
> >
> > Regards
> >
> > Dale Fraser
> >
> >
> >
> > http://learncf.com
> >
> >
> >
> >
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Andrew Scott
> > Sent: Monday, 24 September 2007 4:44 PM
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> >
> > Scott,
> >
> >
> >
> > How does that help me, backup a database remotely to my local machine?
> > The only options are to the servers hard drive, or tape?
> >
> >
> >
> > 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 4:18 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
> >
> >
> >
> >
> > Umm Define easy?
> >
> >
> >
> >
> >
> > eg:
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
> >
> >
> > 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...
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > >
> >
>
>
> --
>
>
>
> Senior Coldfusion Developer
> Aegeon Pty. Ltd.
> www.aegeon.com.au
> Phone: +613  8676 4223
> Mobile: 0404 998 273
>
>
>
>
>
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.co

[cfaussie] Re: MSSQL 2005 Developer Edition

[Steve Onnis]

You are playing with fire with a comment like that Dale.  I am sure that a
lot of people on this list and others would disagree with you saying that
mySQL is a toy.  Feature wise it is getting up there. From my experience it
is certainly up there in relation to speed and it has a few nice features
that MSSQL doesn't have.

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Monday, 24 September 2007 8:45 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition


I understand why you would like it.

But MySQL is a toy and it makes sense

MSSQL is for large databases, I don't see how this would work to backup
gig's of database to some remote disk. In fact I can't see it working very
well on any database of any reasonable size.

Regards
Dale Fraser

http://learncf.com

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, 24 September 2007 5:55 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition


Nice if you have full access to the server?

But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
databases and the MS one I have to get them to back up and place in my ftp
for me to download. With the mySQL ones I backup to my desktop and have no
hassles restoring to a database server here, with no interaction with
support.

Are you seeing the point now?


On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
>
>
> Backup
>
>
>
> Ftp
>
>
>
>
> Regards
>
> Dale Fraser
>
>
>
> http://learncf.com
>
>
>
>
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 4:44 PM
>
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
>
>
>
> Scott,
>
>
>
> How does that help me, backup a database remotely to my local machine? 
> The only options are to the servers hard drive, or tape?
>
>
>
> 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 4:18 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
>
>
> Umm Define easy?
>
>
>
>
>
> eg:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
>
>
>
>
>
>
>
>
>
>
>
>
>
> On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
>
>
> 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...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273






--~--~-~--~~~---~--~~
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

[Dale Fraser]

I understand why you would like it.

But MySQL is a toy and it makes sense

MSSQL is for large databases, I don't see how this would work to backup
gig's of database to some remote disk. In fact I can't see it working very
well on any database of any reasonable size.

Regards
Dale Fraser

http://learncf.com

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, 24 September 2007 5:55 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition


Nice if you have full access to the server?

But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
databases and the MS one I have to get them to back up and place in my
ftp for me to download. With the mySQL ones I backup to my desktop and
have no hassles restoring to a database server here, with no
interaction with support.

Are you seeing the point now?


On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
>
>
> Backup
>
>
>
> Ftp
>
>
>
>
> Regards
>
> Dale Fraser
>
>
>
> http://learncf.com
>
>
>
>
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 4:44 PM
>
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
>
>
>
> Scott,
>
>
>
> How does that help me, backup a database remotely to my local machine? The
> only options are to the servers hard drive, or tape?
>
>
>
> 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 4:18 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
>
>
> Umm Define easy?
>
>
>
>
>
> eg:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
>
>
>
>
>
>
>
>
>
>
>
>
>
> On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
>
>
> 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...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273


--~--~-~--~~~---~--~~
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

[Andrew Scott]

Nice if you have full access to the server?

But this is a shared host, and I have 1 MS SQL databases and 2 mySQL
databases and the MS one I have to get them to back up and place in my
ftp for me to download. With the mySQL ones I backup to my desktop and
have no hassles restoring to a database server here, with no
interaction with support.

Are you seeing the point now?


On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
>
>
> Backup
>
>
>
> Ftp
>
>
>
>
> Regards
>
> Dale Fraser
>
>
>
> http://learncf.com
>
>
>
>
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Andrew Scott
> Sent: Monday, 24 September 2007 4:44 PM
>
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
>
>
>
> Scott,
>
>
>
> How does that help me, backup a database remotely to my local machine? The
> only options are to the servers hard drive, or tape?
>
>
>
> 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 4:18 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: MSSQL 2005 Developer Edition
>
>
>
>
> Umm Define easy?
>
>
>
>
>
> eg:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx
>
>
>
>
>
>
>
>
>
>
>
>
>
> On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
>
>
> 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...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

--~--~-~--~~~---~--~~
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

[Dale Fraser]

Backup

 

Ftp

 

Regards

Dale Fraser

 

http://learncf.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, 24 September 2007 4:44 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition

 

Scott,

 

How does that help me, backup a database remotely to my local machine? The
only options are to the servers hard drive, or tape?



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 4:18 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: MSSQL 2005 Developer Edition

 

Umm Define easy? 

 

eg: http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx

 

 



 

On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote: 

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
-~--~~~~--~~--~--~---