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

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

can u give us query

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

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

Thanks in advance...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.