As I understand it, look at it this way.
CF maintains an open connection with the db. It is the one user, in effect,
and manages requests for data from users.
Look in the folder where you store your mdb's. When CF is accessing one of
them, you will see a .ldb file there too.
I would say that if you are in doubt as to whether or not Access can handle
something, then use another db! Although having said that, I have used
Access as a back end db for a lot of projects, some of which get pretty high
traffic, and it hasn't let me down yet!!
Regards
Will
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 April 2001 10:33
To: CF-Talk
Subject: RE: limitations of Access
You can have multple users of an access database. You just need to set it
for shared use.
To minimise conflicts it is usual to split the database into two, with the
interface and any data which is static held on a local machine with linked
tables to shared data held on a server.
Up to 97 access has page level as its lowest locking level, a page being
2KB, so writing to a row would lock (2kb/rowsize) rows. With 2000 page size
has doubled but row level locking is now possible. `
-----Original Message-----
From: Derek Havelock [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 16:43
To: CF-Talk
Subject: RE: limitations of Access
Can I possibly add a question to this string ...
Larry, you mentioned that:
>we were running an auction site using Access that always was running at
least 30 concurrent
>sessions at a time with 50000 items in the database and did not appear to
have a major problem.
I don't see how that is possible - but am hoping that you can teach me
something here.
At the last place I worked, when more than one person accessed the same
Access file, they were simply locked out. This would frequently happen when
a salesperson tried to get into the product database to answer a customer
query, but a product manager would already be in the file. - major disputes
in the office when the customer can hear every word down the line :-)
You mention "30 concurrent sessions" by which I take it to mean that 30
users can be within the same file at the same moment in time. Surely, with a
file-based package, this is not possible? If you can indeed do this, I would
greatly appreciate any info you can give me to solve such a problem.
Kindest regards,
Derek
BTW - a leap from Access to Oracle!!!! A major leap!!!!!!
:-)
IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]
-----Original Message-----
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 15:40
To: CF-Talk
Subject: RE: limitations of Access
I am not totally 100% sure on this, however I do know that we were running
an auction site using Access that always was running at least 30 concurrent
sessions at a time with 50000 items in the database and did not appear to
have a major problem. We did upscale the site to Oracle however just to NOT
have any possible problems.
I know this is not what you wanted to hear, but it is some proof that the
low numbers may not be totally accurate.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-----Original Message-----
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 12:33 AM
To: CF-Talk
Subject: limitations of Access
Hi all,
I am doing a quote for a client that has an existing CF site using Access.
They are a professional organisation hosting their own server and I'm trying
to get them to steer away from Access, as I think the site has the potential
to get more hits than Access can easily handle. So far they are determined
to stick with it.
I need some ammo... I know Access is not suitable for the job they want it
to do, but I'm not sure of the facts and figures. I think someone once
before said that Access cannot handle more than 5 concurrent users but I'm
not 100% sure.
So does anyone have any concrete figures on the capabilities of Access?
Thanks,
K.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
