select max help

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

Anon

You could always try;

SELECT max(n_id) AS max FROM table ORDER BY n_id DESC LIMIT 0,1000

Although I'm not sure it'll give you any signifficant performance boost. You might even want to try;

SELECT n_id FROM table ORDER BY n_id DESC LIMIT 0,1

Do you have an index on n_id? If not, make one! :-)

Anon

I do have an index on n_id. I will try these in a few minutes. I will report back my results. Thanks

Anon

SELECT max(n_id) AS max FROM table ORDER BY n_id DESC LIMIT 0,1000

that is the one that would do what i need but that did not speed the site up at all. Any other suggestions?

thanks again