> its running on mysql at hms on shared account. I realize what you are > saying about shared accounts vs vps accounts and I have the biggest > vps that they offer but the client doesnt want it on a vps account so > that takes that away.
Ironically enough I was searching on Google for something else and came across yet another blog thread on this kind of issue on HMS shared hosting: http://www.trajiklyhip.com/blog/index.cfm/2007/7/2/Web-Hosting--Help-End-My-Pain I was recently browsing the support area for another CF shopping cart, and saw one of their users reporting the same thing, so it's certainly not something unique to my product. > Diagnostics: > The request has exceeded the allowable time limit Tag: CFQUERY This really doesn't tell me much....other than that you are getting some of the timeouts people have typically gotten on HMS shared servers. Generally what we see is they are random....different pages or queries, or cfloop errors or other timeout errors. Or what I often see are errors about not enough storage to start a new thread. Other people sometimes just get general JRun errors. If this is not what you are seeing, if you are getting the same exact error for the same query every time, then that may indeed be something worth looking into. > unfortunately I just cant tell the client that the errors are being > caused by hms because they go and look at the site and its all running > right except the cart and that tells them its the cart. Well, I'm not going to keep arguing it with you, because there is *nothing* I can do about it on the software-side. Believe me, if we had been able to find a reproducible issue with the software, it would certainly be fixed. Since I know nothing about your site, I can not do anything more than speculate about why the problem shows up with the webstore and not elsewhere, but as I've said, this simply isn't something we've typically seen with other stores. If there was such a serious problem with the software, I'd be hearing about it from everyone, VPS and dedicated users as well. We don't even see it on most shared plans, generally when I get a report about timeouts, I could put money on it being a HMS account. I've given you links to other people that have reported the same problems on HMS with other sites and applications, which should help you in discussing the issue and options with your client, and you can always try to get HMS to move it to another server, or put it in its own application pool to try and reduce the issues. Or, there are a number of folks on the yahoogroup for CFWebstore that do hosting as well, you can always post on there that you are looking for more reliable shared hosting. Or, if you can manage your own server, take a look at Viviotech's VPS plans which start at $29.95 with BlueDragon included. Or you can take the route of doing your own shopping cart, that certainly might be the answer for you as well, if moving is not an option. If you only need fairly simple functionality, it's very likely a basic cart is not going to have the same issues that a fairly heavy-duty app like mine can when resources are stretched. --- Mary Jo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:239558 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
