get data

[Anon]

I really need someone to help me with this.

here is my command i use:
$num_sql = "SELECT max(n_id) AS max, count(*) AS new_articles FROM news WHERE cat_id = $my_cat_id";

Now, we have 70,000 records. Is there a way to do this to speed it up? I tryed using a LIMIT 1000 at the end, but it still seems to read thru all the entries. This is a major issue for me right now. I would be forever in debt if someone could help me out.

Thanks

[Anon]

Put an index on cat_id.

[Anon]

OMG!!! You RULE!! Thank you so much...