tags:

views:

471

answers:

2
+2  Q: 

Drupal View display - setting a limit for the query results

I have a View set to grab the latest forum posts. That's working fine, but I'd like to limit it to get the last 5 records only. I know I can display only 5 with PHP but I don't want a larger query than I need. I can't find any option for this in the View.

thanks

A: 

Yep. There is an option that limits it called 'Items to display:' under Basic Settings.

Kevin  2010-04-02 13:55:22
Thanks Kevin. I see an option called "Items per page". I see what it's doing now. After I set"Use Pager" to "No", then it changes "Items per page" to "Items to display". But when I preview the query it creates, I don't see a LIMIT in there, which tells me that it's getting all the rows in the table. Is this a limitation of queries in the View?
EricP  2010-04-02 14:15:17
That I am not sure of. You could use PHP with the Views hook _views_pre_execute and modify the $view->build_info['query'] and append LIMIT 5 near the end. Not elegant but if you're looking for performance, that's one way. Views has so much going on internally though, you may want to dig in and see what Items to Display affects.
Kevin  2010-04-02 15:06:51
The query preview in Views is not the final query that's sent to the database engine. The final query includes a LIMIT already, which you can see by turning on query log in the devel module.More general advice: few people can write better queries than Views writes automatically. If you're one of those people, you probably shouldn't be using Views. And if you're not, you should just let Views write the queries and stop worrying about the details.
Scott Reynen  2010-04-02 15:37:58
That's pretty much what I thought but didn't have time to bust out devel and dig in. Otherwise that option wouldn't be so useful.
Kevin  2010-04-02 16:50:03
Thank you. That's good to know.
EricP  2010-04-04 11:13:45
A: 

##

vg fg  2010-08-20 10:53:43

related questions

Batch node operations in Drupal 5
How do you make php's json_decode compatible with firefox's javascript?
Drupal CSS URL Problem
Is it possible to deploy an already built Drupal site?
php Access violation
Creating an online catalogue using Drupal, what are the best modules/techniques?
How do I upgrade from Drupal 5 to 6?
How does AOP work in Drupal?
Any quirks I should be aware of in Drupal's XML-RPC and BlogAPI implementations?
What is the simplest way to handle images in Drupal?
How can I change some of Drupal's default menu strings without hacking the core files or using the String Override plugin?
Why is my Drupal site logging out users when a Javascript function is called?
How do I add a "last" class on the last <li> within a Views-generated list?
How do I determine if I should install Drupal 5.x or 6.x?
Missing label on Drupal 5 CCK single on/off checkbox
learning drupal fast track: how to create a stackoverflow clone?
How do you remove the default title and body fields in a CCK generated Drupal content-type?
How do I create a node from a cron job in drupal?
How to quickly theme a view?
Where is the best place to get Drupal & Sugar CRM developers?
How to get rid of Javascript Runtime Errors when running PDT + XDebug in Eclipse?
What makes Drupal better/different from Joomla
Include CSS or Javascript file for specific node in Drupal 6
What version of TinyMCE will work in Drupal 5 with google chrome?
How can I change the way my Drupal theme displays the front page