Jump to content


Photo

Optimizing IPB


  • Please log in to reply
No replies to this topic

#1 DCoder

DCoder

    One of the Few

  • Members
  • 331 posts
  • Location:Lithuania, Central Europe
  •  Old Grumpy Bastard

Posted 17 January 2006 - 04:08 PM

Well, I've been finetuning the IPB installation at RenProj forums, like validifying the XHTML/CSS code, tidying up the PHP / SQL, the usual. And I've come across an odd problem:

I do all the optimizing work at my localhost, where I have SQL Trace Mode enabled. I've fixed quite a few SQL queries by adding extra indexes and limits, yet this one is persistant:
SELECT * FROM ibf_members_converge WHERE converge_email='dcoder1337@gmail.com' LIMIT 1


When it is executed, Trace mode fires a warning about requiring a full tablescan, phpMyAdmin > EXPLAIN says it can use an index and doesn't need a full tablescan. Which of them is correct and why the hell is such a conflict happening in the first place?

(Yes, there is an INDEX on the converge_email column.)
Ares - How do you want to improve YR today?
What's stopping you from migrating to Ares? We can't implement it unless you tell us!

ModEnc - C&C Modding Encyclopedia | Modders' Quote Database | Yet Another C&C Modding Forum




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users