Having come from where you are at not that long ago, I can tell you that picking up the basics of MS SQL server will be very easy. The parts of Access that you use in a CF application are fairly similar to the parts of MS SQL you will use for a CF application, the creation of tables, fields and relationships. Adding, editing and deleting are all almost the same.
Now of course there is a LOT more to MS SQL, but the vast majority of this stuff falls under the "DBA" role, and that person is at the ISP. So, unless you are planning on completely taking over the database either in-house or out. You shouldn't have to worry about many of these issues. At least not just yet. HTH -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:43 PM To: CF-Talk Subject: RE: Urgent: Performance Help Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a "real" engine after I had a site that might drive some traffic. I may have to change my plans..... Thanks Andy -----Original Message----- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: >No, don't recommend Viagra....the problem is I just won't stop..... > >My ISP is accusing me of writing code that keeps threads open long after they >should be closed and are threatening to shut down my site. Good news is that >I don't have many users yet, Bad news is that they can't give me any details >because they don't have their analytical software, Cognos, up yet. > >Is there a site anywhere that can help we walk through my code and try to >figure out what the problem is? Running MX and Microsoft Access. It runs >fine as a single user on my PC. > >Thanks for anything you can give me.... > >Andy > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137386 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com