Decreasing query time?

[subodh_dg]

I have tested this query :

SELECT ID, Title, Author, Article FROM data_articles
WHERE Category = 'xyz' ORDER BY Title LIMIT 0 , 30

The time required to execute query is 10.4506 sec which may be large. I have more than 22,000 records in the table.
How should I modify theory so the time should be less. Using "select * " also increases the time?

[Sxooter]

Telling us what dbms you're using would be a real help.

In PostgreSQL I'd tell you to create an index on (category,title) and / or cluster on it.

[subodh_dg]

I am using mysql. Can you please tell me what is indexing or any good article?

[Sxooter]

subodh_dg wrote:

I am using mysql. Can you please tell me what is indexing or any good article?

There's quite a bit in the mysql docs on it. A very very quick looking over the docs shows that mysql does support multicolumn indexes:

multi-column indexes