How to retrieve top 10 revords in mysql 4

[vaishalinagare]

hi,
i'm using LIMIT command in mysql query to retrieve top 9 records but it takes 10-12 min. pl help. thank you in advance

[nikesh.yadav]

how many records are in ur database?
and i thought limit is best...

[nikesh.yadav]

can u give us query

[pritaeas]

Are you using indexes ?

[dickersonka]

Agree with pritaeas, definitely use indexes.
Also if you have a lot of records, you probably don't want to use LIKE or 'string%'

take a look at full text searching if the indexes don't straighten up the issue

[Shanti C]

hello dickersonka and pritaeas...
Please give clear explanation about mysql indexing...how to use??

Thanks in advance...

[pritaeas]

Well. If he wants more info on how indexing can improve his query, we need to see the query first.

However, there's always this: http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html