Maybe I am just biased against Access for all Web sites, but, yes, Access will be a bottleneck regardless of what you do. It handles multiple requests poorly and has sub-optimal response times even on tiny queries. The moment you have any kind of load on the thing your response times will shoot up and your client will start experiencing time outs waiting for pages to generate.
What I always say is... If you are hosting the site yourself and cannot afford a comercial package, use a freeware database like MySQL or Postgres (the former is not hard to learn, the latter is quite powerful). You can also try SAPDB (another free database which has an Oracle emulation mode I am fond of) but I understand many people are having problems getting started using it. If you are hosting with a provider, get the client to cough up the extra cash for a slightly better database, i.e. commercial ones like SQL or Oracle, or even just MySQL which a lot of providers support. You will like the improved response times, and the price difference is usually minimal. If you are stuck with Access, give the client a good caveat emptor and tell him or her what the limitations mean. Make sure the client understands and get something in writing if possible. M -----Original Message----- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 12:24 PM To: CF-Community Subject: RE: Site On Thu, 26 Sep 2002 10:58:07 -0400, Haggerty, Mike wrote: > This can be done in CF, your question was whether this can be done easily > with CF. > > The answer depends on a numbder of factors including the skill level of the > developer and the expectations of the client. The skill level is not that high. > Access will be a major > bottleneck, and your client might have issues with performance on the final > product. Even if you have pointers in the database pointing to the file on the server rather than including the binary into the database? > Unhappy clients are never 'easy'... > > As for fees, you may want to avoid charging a flat rate on this project and > instead give an estimate based on the number of hours it would take you to > complete the work. In order to accurately estimate the number of hours, you > will probably need a more detailed set of requirements than what you have > here and some sort of an understanding of exactly what is necessary to > produce the final product. Also ask youself about secondary issues, like > hosting. Know where they are going to host the product and whether or not > you are going to have to get involved in setting it up. > > You should be compensated for your time spent working on side issues, maybe > just not at as high a rate. > > M ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
