Limiting number of records to show.

From: Wim <wdh(at)belbone(dot)be>
To: pgsql-novice(at)postgresql(dot)org
Subject: Limiting number of records to show.
Date: 2002-05-03 08:47:01
Message-ID: 3CD24E85.8000008@belbone.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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!

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Adams (DNS) 2002-05-03 10:00:04 Re: Limiting number of records to show.
Previous Message cristi voinicaru 2002-05-03 06:41:51 unsubscribe