≡

wincent.dev

  • Products
  • Blog
  • Wiki
  • Issues
You are viewing an historical archive of past issues. Please report new issues to the appropriate project issue tracker on GitHub.
Home » Issues » Feature request #1677

Feature request #1677: Analyze "needles" table with a view to adding column indexes

Kind feature request
Product wincent.dev
When Created 2010-09-01T17:51:03Z, updated 2010-09-02T08:19:15Z
Status open
Reporter Greg Hurrell
Tags no tags

Description

Currently has 500k records and performance is ok for now, but I'd like to do some thorough investigation of this table and see if I could get better performance by adding more indexes.

Mostly interested in SELECT and JOIN performance. Not worried so much about INSERT.

Comments

  1. Greg Hurrell 2010-09-01T17:52:50Z

    Summary changed:

    • From: Analyse "needles" table with a view to adding column indexes
    • To: Analyze "needles" table with a view to adding column indexes
  2. Greg Hurrell 2010-09-02T08:19:15Z

    Worth a read:

    • http://hackmysql.com/case4: "How To Index For Joins With MySQL"
Add a comment

Comments are now closed for this issue.

  • contact
  • legal

Menu

  • Blog
  • Wiki
  • Issues
  • Snippets