Skip to Content.
Sympa Menu

lyceum-users - [Lyceum-users] important database optimization

lyceum-users AT lists.ibiblio.org

Subject: Lyceum-users mailing list

List archive

Chronological Thread  
  • 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.

Top of Page