lyceum-users AT lists.ibiblio.org
Subject: Lyceum-users mailing list
List archive
- From: John Joseph Bachir <jjb AT ibiblio.org>
- To: lyceum-users AT lists.ibiblio.org
- Subject: [Lyceum-users] important database optimization
- Date: Sun, 4 Mar 2007 02:30:36 -0500 (EST)
I discovered a VERY crucial missing database index the other day. All the details are here:
<http://lyceum.ibiblio.org/2007/03/02/last-night-a-b-tree-saved-my-life-or-how-to-do-a-simple-index-audit-to-fix-a-slow-query/>
But you don't need to read all that. What you do need to do, for an instant super speedup on your Lyceum installation, is execute this command at the MySQL command line:
ALTER TABLE post2cat ADD UNIQUE INDEX category_id (category_id,post_id);
Enjoy.
--
John Bachir
http://lyceum.ibiblio.org/
http://blog.johnjosephbachir.org/
aim/yim/msn/jabber.org/gtalk: johnjosephbachir
713-494-2704
irc://irc.freenode.net/lyceum
- [Lyceum-users] important database optimization, John Joseph Bachir, 03/04/2007
Archive powered by MHonArc 2.6.24.