Performance issue

[cleanair4me]

For the past couple years our Cold Fusion 8 sites (working with Databases) on Windows 2003 goes down alot. It seems the System Admins have to reboot Cold Fusion to get it back up about 2 or 3 times a week. They are not sure what is causing it to go down but think it might be related to Access databases working with Cold Fusion. Is this a configuration issue or is Access a recurrent problem working with Cold Fusion where it brings it down alot? Please advise.

I think this Tek-Tips site is using ColdFusion and it seems to have good performance so I know ColdFusion (on JRun) does work in a lot of places.

 

[powella]

Can you be more specific? They are getting a blue screen or what is meant by "goes down"? Are you running 8.0.1? CF 8 has not been out a couple of years so you must have upgraded and you were having problems in 7 too. ... ?

 

[philhege]

You should dump Access for an enterprise-class database. If you can purchase Oracle or SQL Server, by all means do so; if not, you can use MySQL.

Access is not meant to handle heavy usage. So no matter what version of CF you deploy, the database will be the problem.

The only way to be sure is to monitor the traffic between the CF server and the database, but I can almost guarantee that Access is the culprit here.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[cleanair4me]

Thanks, we are in process of migrating to Oracle and MySQL for our CF 8 applications on Windows 2003 but it will take about another year to get the 40 or more small Access databases migrated over.


By Go down I mean all database driven sites (Oracle,Access and MySQL) do not show with the page trying to load and eventually Datasource not found or JRun error message. After System Admin recycles CF Services it works.

 

[philhege]

Definitely put a sniffer on the traffic and find out what transaction or activity is causing the bottleneck.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.