| Posted By |
Discussion Topic: Car Site
|
|
mbear21 |
09-05-2006 @ 5:26 PM |
|
|
New Member
Posts: 33
Joined: Aug 2006
|
I created this for a car dealership. Rather simple, but yeah. The host they ended up using isn't that great, so 1 in 8 clicks you'll get a 'cannot connect to db' error.
www.futureclassicsnj.com/index.cfm
I used the page links tutorial off EasyCFM, worked awesomely. 
I just did the Coldfusion, not the layout.
This message was edited by mbear21 on 9-5-06 @ 5:29 PM
|
|
Webmaster |
|
09-05-2006 @ 9:14 PM |
|
|
Administrator
Posts: 4533
Joined: Jan 2002
|
1 in 8; you using MS Access?
Pablo Varando 
Senior Application Architect
EasyCFM.COM, LLC.
904.483.1457 \\ mobile
webmaster@easycfm.com \\email
|
|
mbear21 |
|
09-05-2006 @ 9:23 PM |
|
|
New Member
Posts: 33
Joined: Aug 2006
|
No, we are using MYSQL database. Every so often we get:
[MySQL][ODBC 3.51 Driver][mysqld-4.1.20-max-log]Lost connection to MySQL server during query
Refresh once and it goes away, but it still seems to be happening ALOT more than it should. I just went to our site to get the exact error to paste above, and it only took 2 page loads.
Currently using for hosting: www.ixwebhosting.com
|
|
mquack |
|
09-05-2006 @ 11:27 PM |
|
|
Moderator
Posts: 1544
Joined: Jan 2005
|
SQL Server and a reputed host will solve that problem
http://www.rachelqueensg.com
|
|
krisbrixon |
|
09-21-2006 @ 12:54 PM |
|
|
Senior Member
Posts: 233
Joined: Feb 2005
|
Couple of options if you can not change the host.
Cache the queries.
put the queries in a function and if they error then run the function again. (don't put it in a loop, just run two or three times.) That will give you a few chances to not fail.
If this is a low load site then don't use a database, use something like WDDX.
It is possible the timeout on the database and the time out on the CF server are different, see if the hosting company will make sure they have the same timing.
Kris Brixon
www.brixontech.com
|
