Limiting number of records to show.

Hello,

I have a table with over 1.000.000 records. I'd like to limit the
maximum number of records to display, so if one my users opens the whole
table, he will see only for example 1000 records.
If I don't limit and they open the whole table, the server's CPU-load
raises to 150...
I searched the docs, but couldn't find the info....

Is this possible? If yes, how do I do this?

Thanx!