RE: from 6 to 7
Even mySQL would be an upgrade if you can't afford the SQL upgrade. At least it's reliable. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 5:17 PM To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a stability issue with Win2003. Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
Oh, I know all about how bad Access is. The fact remains that this is an old, semi-poorly written application (from a maintenance standpoint, not a functional one), which would require LOTS of attention to upgrade to mySQL or SQL Server. With all the billable work piling up around here, I'd like to just leave this app until I can give it the proper time for the upgrade. All of my apps these days are using a real DB. I really am impressed with mySQL lately, though. As Ray Camden wrote in his blog a few days ago, there is a whole world of features that I didn't ever know about. Anyways, thanks for the help guys, it was appreciated. Ray Burns, John D wrote: Even mySQL would be an upgrade if you can't afford the SQL upgrade. At least it's reliable. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 5:17 PM To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a stability issue with Win2003. Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists
RE: from 6 to 7
Most ISP's should offer at least SQL EXPRESS 2005 for free... -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 9:49 AM To: CF-Talk Subject: RE: from 6 to 7 Even mySQL would be an upgrade if you can't afford the SQL upgrade. At least it's reliable. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 5:17 PM To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a stability issue with Win2003. Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
hmmm...got me thinking...what is the actual licensing for sql express? so far my googling has failed...previous versions of MSDE weren't good for anything more than a small app due to the throttling, but this version doesn't have that anymore...the limits of 1GB of RAM, 1 processor and 4GB database size put a lot off web apps within reach on that platform. Does anyone know of a link to the actual license agreement for SQL Express? I'd like to see what the fine print says. On 1/24/06, Russ [EMAIL PROTECTED] wrote: Most ISP's should offer at least SQL EXPRESS 2005 for free... -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 9:49 AM To: CF-Talk Subject: RE: from 6 to 7 Even mySQL would be an upgrade if you can't afford the SQL upgrade. At least it's reliable. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 5:17 PM To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a stability issue with Win2003. Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message
RE: from 6 to 7
hmmm...got me thinking...what is the actual licensing for sql express? It's free, and you only need to worry about licensing if you plan to redistribute it with your applications. SQL Server 2005 Express: http://msdn.microsoft.com/sql/express/ Comparing SQL Server 2005 Express and MSDE: http://msdn2.microsoft.com/en-us/library/ms165672.aspx Register for SQL Server Express Edition Redistribution Rights: http://www.microsoft.com/sql/editions/express/redistregister.mspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
I just downloaded the package to see the license since I couldn't find it on any of the pages...and it does specifically state that you may not: use the software for commercial software hosting services So, it looks like hosts offering it free is out. On 1/24/06, Dave Watts [EMAIL PROTECTED] wrote: hmmm...got me thinking...what is the actual licensing for sql express? It's free, and you only need to worry about licensing if you plan to redistribute it with your applications. SQL Server 2005 Express: http://msdn.microsoft.com/sql/express/ Comparing SQL Server 2005 Express and MSDE: http://msdn2.microsoft.com/en-us/library/ms165672.aspx Register for SQL Server Express Edition Redistribution Rights: http://www.microsoft.com/sql/editions/express/redistregister.mspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230380 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
from 6 to 7
Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
What database are you using? Perhaps it's an issue with the database drivers that came with CF7. Also have you installed updater1? -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
What database? -jim On 1/23/06, Ray Champagne [EMAIL PROTECTED] wrote: Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
As a side question, does the site appear to perform slower on the new server? If not, it seems rather odd that the server times out periodically trying to connect to the database but that it doesn't act slower on regular page calls. As a quick fix, you could possibly increase the timeout time for the connection to the database. That doesn't solve the root problem, but may get it to at least stop timing out. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:05 PM To: CF-Talk Subject: Re: from 6 to 7 That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
When converting from 6 to 7, I as well experienced Problems with using MS Access even with basic queries. It came down to the drivers that was used. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a stability issue with Win2003. Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
Access is never a good web DB solution. It was never designed to handle that kind of traffic. It was designed to handle a salesman's client list or a home user's address book. It is one of the most abused pieces of software in the history of software... Eric -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, 23 January 2006 16:17 To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a stability issue with Win2003. Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of their network. On 1/23/06, Burns, John D [EMAIL PROTECTED] wrote: As well as the question other have asked about which database are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to upgrade my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a features release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
