Are you talking about a table with a million entries from which some
relatively small number of "imail" users? I cannot imagine such a large
number of users authenticating with access or imail even on a piii 900 dual
system. HOw many users of this massive database actually authenticate a
day???
Realy the matter must take into account both the datatable size as well as
the frequency with which authentication occurs.
I have some of the same concerns because I have about 100 fields in my imail
user table. Does anyone else have any experience with table size, heavy
authentication and the value (if any) of multiple servers for the data
tables???
Seems that access would give you problems with
----- Original Message -----
From: "Joker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 21, 2000 8:22 PM
Subject: Re: [imail] External DB design approach
> Yes and no.. Depends on the server also. I use dual PIII 900 with 2 gig of
> ram SDRAM and see no problems with over a millinon in there but on a
slower
> server you might.
> At 09:56 AM 8/22/2000 +0700, you wrote:
> >So, This mean that number of fields in DB table shouldn't reflect much on
> >performance? ..
> >
> >Regards,
> >Nopchai
> >
> >--------- Original Message ----------------------------------
> >From: Joker <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >Date: Mon, 21 Aug 2000 22:49:09 -0400
> >
> > >I have seen MS-Acces with close to a million entries and work fine.
> > >At 09:41 AM 8/22/2000 +0700, you wrote:
> > >
> > >>Hi all,
> > >>
> > >> Anyone can give me an idea.. will there be any benefit
if I
> > >> split External DB for IMAIL usage & another DB to keep detail
information
> > >> of users. The idea is to keep minimum fields that IMAIL use for
external
> > >> DB authentication(this DB will be also used for our own developed web
> > >> application for authentication)
> > >> Will that be any useful to do this approach? .. since we
will
> > >> have to modify some code in EZsignup. Also One drawback I see for
this
> > >> approach is that we can't have user update their own information on
their
> > >> IMAIL user info changing page.(Does IMAIL keep it in DB also or LDAP
> > only?)
> > >>
> > >> if this approach doesn't provide any benefit to me, I may
> > >> stick with the old one.(single DB table)
> > >>
> > >> We may use 2 MS-Access DB file (2 System DSN) one for
IMAIL
> > >> table, another for user info.
> > >>
> > >> What is possible scale for using MS-Access ? .. thousands?
> > >>
> > >>Thanks & Regards,
> > >>Nopchai
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>______________________________________________________________________
> > >>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
> > >
> > >
> > >
> > >
> > >
> > >______________________________________________________________________
> > >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
> > >
> >
> >
> >
> >______________________________________________________________________
> >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
>
>
>
>
>
> ______________________________________________________________________
> 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
>
______________________________________________________________________
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
