Welcome, Guest. Please Login or Register.
March 28, 2024, 02:16:09 PM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  General Category  |  Feedback  |  Mysql Optimizer - where did it go? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Mysql Optimizer - where did it go?  (Read 33205 times)
akpcep
Noobie
*
Posts: 33


I'm not a f*ckin llama.

WWW
Mysql Optimizer - where did it go?
« on: February 26, 2004, 02:16:25 PM »
Reply with quote

Hi,

I seem to remember there was a little script you could run that added extra indices to the Yabb tables - I've been searching these boards for an hour but all the links to it are dead. Can someone please point me to it's current location?

Many thanks.
Logged

[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:Mysql Optimizer - where did it go?
« Reply #1 on: February 27, 2004, 04:06:09 AM »
Reply with quote

Well, you don't want *extra* indexes or anything, just the right amount of them.

However, if you click the "Optimize Database" link in your admin center it should speed things up a little.

-[Unknown]
Logged
akpcep
Noobie
*
Posts: 33


I'm not a f*ckin llama.

WWW
Re:Mysql Optimizer - where did it go?
« Reply #2 on: February 27, 2004, 07:34:14 AM »
Reply with quote

Thanks for your reply!

I think I found a thread in which the indices were listed, and my install already had them all. I've turned off the click log and stats and what have you so I think it's about as fast as it's going to get.

Hey ho!
Logged

Pages: [1] Reply Ignore Print 
YaBB SE Community  |  General Category  |  Feedback  |  Mysql Optimizer - where did it go? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.023 seconds with 20 queries.