[development] Drupal 7 Entities - view random node
nan_wich at bellsouth.net
Mon Jan 24 00:53:58 UTC 2011
Larry, I am curious. Being that you are a database guru, this fits in with an
issue for my Quotes module, as does the original post. [BTW, Blaine, rather than
write you own, you might want to look at Quotes.]
One of the users who has an unusual number of quotes (~12K) says that ORDER
RANDOM LIMIT 1 is not very efficient and gets fairly slow at that size. There
are discussions elsewhere on the web to back up that assertion.
Do you find that to be true? Do you have a simpler way around it than keeping a
separate index of the applicable nodes?
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Larry Garfield <larry at garfieldtech.com>
To: development at drupal.org
Sent: Sun, January 23, 2011 7:41:34 PM
Subject: Re: [development] Drupal 7 Entities - view random node
I did that all the time in Drupal 6 using Views. It's dead simple. (Order
random limit 1, done.) I haven't tried doing it in Drupal 7, but I'm sure the
same method still works.
On Sunday, January 23, 2011 1:33:34 pm Blaine Lang wrote:
> I have a need for a block that will display a random quote. Node type =
> 'random_quote' and only 1 random record should be displayed
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the development