Len Conrad wrote:
>The db size isn't the issue, nor is the table size, it's how many
>simultaneous accesses are workable and the type/granularity of
>locking. MS Access's locking does not support 100's or 10's of
>simultaneous accesses that required for a mail server supporting
>1000's or 1O's of 1000's of interactive users authenticating against
>the single Imail user table.
I agree completely. I have seen very large Access databases work just fine,
but in the situation you discribed there will certainly be problems.
What I don't know is when this occurs on a typical Imail system. How often
is the database actually used if there are webmail-users only. If the
database connection is opened only when a webmail user logs in Access should
be able to handle a very large number of users. On the other hand if there
is a new database connection every time a user requests a new page Access
will not handle 1000:s of users too well.
Does anyone know how this works? When can we expect trouble with Access?
Thomas Svartback
Helsinki / Finland
______________________________________________________________________
The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc.
Questions, Comments or Glowing Praise...... mailto:[EMAIL PROTECTED]
Searchable List Archive.... http://www.mail-archive.com/[email protected]
To Manage your Subscription......... http://humankindsystems.com/lists
