select max - quick one..

[Anon]

I have about 70,000 entries in my database.

I run a $num_sql = "SELECT max(n_id) AS max -- type command. It takes like 10 secs to get the results. Is there a way i can limit the select to just the last 1000 entries in the database?

Thanks

[tomhath]

If you have Version 3.22 or higher of mysql you should look into adding an index on that column. Manual gives the details.

[Anon]

what would making n_id an index do? how would that speed things up?

Thanks

[Anon]

just looked n_id is set as a primary index.

[Anon]

Come on.. some one please help me.