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 <[EMAIL PROTECTED]> 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
> [email protected]
> http://openser.org/cgi-bin/mailman/listinfo/users
>
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
