[Users] using aliases or dbaliases

[Daniel-Constantin Mierla]

On 05/02/2006 10:47 AM, unplug wrote:
> Thank.  But the number of field between aliases & dbaliases are
> totally different.  Table aliases has 12 fields and table dbaliases
> only has 4 fields.  Why there is a difference If they are
> interchangable?
The 'aliases' has same structure as 'location' table, since the same 
module (usrloc) is used to perform the query. db aliases keeps only the 
required fields for an alias (alias username and domain for each user).

Cheers,
Daniel

>
> On 5/2/06, Daniel-Constantin Mierla <daniel at voice-system.ro> wrote:
>> Hello,
>>
>> On 05/02/2006 06:03 AM, unplug wrote:
>> > What is the difference between using table of aliases & dbaliases?  As
>> > I know, openser will load the records in aliases to memory when it
>> > starts.  There is a problem when the aliases table contains over
>> > 15,000 records and openser will fail to start due to the memory
>> > problem.  As search from the module document, dbaliases can be used to
>> > replace aliases.  The records in dbaliases store in DB instead of
>> > memory when openser starts.  Everytime, openser will query the DB for
>> > the alias of an account.  Am I right?
>> yes.You can increase the speed of database query by tunning the caching
>> of mysql server.
>>
>> Cheers,
>> Daniel
>>
>> >
>> > _______________________________________________
>> > Users mailing list
>> > Users at openser.org
>> > http://openser.org/cgi-bin/mailman/listinfo/users
>> >
>>
>