2 May
2006
2 May
'06
9:54 a.m.
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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users