[UPHPU] mysql index

Joseph Scott joseph at josephscott.org
Mon Mar 29 16:20:10 MDT 2010


On Mon, Mar 29, 2010 at 4:13 PM, Eric Goebel <ericgoebel at gmail.com> wrote:
> I've found that the between operation doesn't use the index very well.
> Is there another type of index I could use or a better way to optimize
> this data for a faster lookup?


Sounds like you've run EXPLAIN on this query then.  What does the
EXPLAIN output look like?


-- 
Joseph Scott
joseph at josephscott.org
http://josephscott.org/


More information about the UPHPU mailing list