[imp] horde_prefs

boiboi alavaren boiboi@stberlin.com
Mon, 11 Mar 2002 07:42:01 +0800


There was no index for pref_uid/pref_name/pref_scope
..just created it. 
Make pre_uid Primary?

Quoting Jan Schneider <jan@horde.org>:

+ Zitat von Jan Schneider <jan@horde.org>:
+ 
+ > Zitat von boiboi alavaren <boiboi@stberlin.com>:
+ > 
+ > > If I'm right, there should be one set per user of identities, 
+ > > last_login,  
+ > > language,  timezone, language,  identities, and default_identity. But
+ > my
+ > > 
+ > > db shows all the previous and every changes. And since I haven't edited
+ > 
+ > > my preferences for weeks, but log in several times daily, my db shows a
+ > 
+ > > few hundred last_login records. 
+ > 
+ > The you probably missed to create an index on
+ > pref_uid/pref_name/pref_scope.
+ 
+ Primary key of course, not index.
+ 
+ Jan.
+ 
+ --
+ http://www.horde.org - The Horde Project
+ http://www.ammma.de - discover your knowledge
+ http://www.tip4all.de - Deine private Tippgemeinschaft
+ 
+ -- 
+ IMP mailing list: http://horde.org/imp/
+ Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
+ Frequently Asked Questions: http://horde.org/faq/
+ To unsubscribe, mail: imp-unsubscribe@lists.horde.org
+ 
+ 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/