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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users