[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/