Hi all,
I have had some experience with db`s and imail, infact db`s and numerous
applications!
I have four machines that run multiple db type applications, some of these
are rather large, and infact one happens to be a sql server with a dual PIII
600Mhz set of cpu`s and 3Gb Ram. The machine is really run hard...it happens
to run around 90 000 transactions an hour, and this is against a db that is
around +- 700Mb in size. The application we sur is a search engine for
scientific reference material.
On the windowze platform this type of arrandement happens to tun
sloooooooowwwwwwwlllllllly.......
Until you load the whole sql server and db into ram, infact I also run the
swap files and os in ram.......this is WONDERFULL!
So what I suggest you people do is find an application called
ramdisk.....run your imail and db server as well as the OS in ram, just make
sure its a dedicated server and is connected to a good UPS.......I rekon
most of you will be pleasantly suprised with this arrangement!
I trust this will shed some light on the matter.
Kind Regards
Neil Solomon
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
lyrihn
Sent: Tuesday, August 22, 2000 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: [imail] External DB design approach
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
______________________________________________________________________
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
