Was the column you were ordering by indexed? | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		mrtron on March 24, 2010 \| parent \| context \| favorite \| on: Digg: 40x Performance Increase by Sorting in PHP R... Was the column you were ordering by indexed?

rythie on March 24, 2010 | [–]

I don't think you can have the fulltext index in the same index as the id since fulltext indexes don't mix with anything.

barredo on March 24, 2010 | [–]

Yes. Fullindex (also MyISAM)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact