I recommend using MS SQL 7, or any other high-end database. I started with MS Access
and wanted to upgrade later. But I wished that I had start with MSSQL from start.
Because its not so hard to install/configure and I had problems converting from MS
access to MSSQL.
I also use a customized table for user authenication that contains other fields than
the imail ones. It works fine, I dont think you can seperate the imail table into two
tables without modifying the imail DLL that talks to the SQL server.
---------- Original Message ----------------------------------
From: "Nopchai Tangtritham" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 22 Aug 2000 09:56:46 +0700
>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