Thread: 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!
u could use. select * from <table> limit 1000 offset 2000; -----Original Message----- From: Wim [mailto:wdh@belbone.be] Sent: Friday, May 03, 2002 10:47 AM To: pgsql-novice@postgresql.org Subject: [NOVICE] 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! ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
Thanx for the fast response! Can I apply this to a user profile? If my users type SELECT * FROM table... they should see only 1000 records... Thanx! Duncan Adams (DNS) wrote: >u could use. > >select * from <table> limit 1000 offset 2000; > >-----Original Message----- >From: Wim [mailto:wdh@belbone.be] >Sent: Friday, May 03, 2002 10:47 AM >To: pgsql-novice@postgresql.org >Subject: [NOVICE] 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! > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/users-lounge/docs/faq.html > >
Well gee, I suppose you could consider writing some sort of rewrite rule. Why not just ask your users to not do that? Joshua b. Jore http://www.greentechnologist.org On Fri, 3 May 2002, Wim wrote: > Thanx for the fast response! > > Can I apply this to a user profile? > If my users type SELECT * FROM table... they should see only 1000 records... > > Thanx! > > Duncan Adams (DNS) wrote: > > >u could use. > > > >select * from <table> limit 1000 offset 2000; > > > >-----Original Message----- > >From: Wim [mailto:wdh@belbone.be] > >Sent: Friday, May 03, 2002 10:47 AM > >To: pgsql-novice@postgresql.org > >Subject: [NOVICE] 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! > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 3: if posting/reading through Usenet, please send an appropriate > >subscribe-nomail command to majordomo@postgresql.org so that your > >message can get through to the mailing list cleanly > > > >---------------------------(end of broadcast)--------------------------- > >TIP 5: Have you checked our extensive FAQ? > > > >http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >