[wp-hackers] Extending query_posts?

[Mattias Winther]

I can't find any specific references to the performance problems you are referring to... Anyone else out there who recognizes this, preferrably with some kind of link for further analysis? Or, someone with a huge database that can run the numbers?

/Mattias

On Mon, 30 Jan 2006 08:10:03 -0500, Scott johnson <fuzzygroup at gmail.com> wrote:
> I'd be careful with that.  My understanding of randomization in mysql
> is that the performance is awful.  I haven't done it myself but that's
> hwat I understand.
> 
> Scott
> 
> On 1/29/06, Sam Angove <sam at rephrase.net> wrote:
>> On 1/29/06, Mattias Winther <mattias at winthernet.se> wrote:
>> >
>> > 1. Are there any other approaches that might work better? I realize
> there are ways to do a hack that does this, but I really want to make it
> feel like it was integrated in the wordpress core.
>> > 2. Is there a hook for looking at and modifying the query just before
> sending it to the SQL server?
>>
>> 2. There's a bunch of them. posts_where, posts_join, posts_orderby
>> etc. Browse WP_Query::get_posts() in classes.php.
>>
>> 1. I don't know how fast it is, but you can do it with ORDER BY RAND().
>>
>> This seems to work:
>>
>> <?php
>> /*
>> Plugin Name: Random Posts
>> */
>>
>> function query_random_posts($query) {
>>         return query_posts($query . '&random=true');
>> }
>>
>> class RandomPosts {
>>         function orderby($orderby) {
>>                 if ( get_query_var('random') == 'true' )
>>                         return "RAND()";
>>                 else
>>                         return $orderby;
>>         }
>>         function register_query_var($vars) {
>>                 $vars[] = 'random';
>>                 return $vars;
>>         }
>> }
>> add_filter( 'posts_orderby', array('RandomPosts', 'orderby') );
>> add_filter( 'query_vars', array('RandomPosts', 'register_query_var') );
>> ?>
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>
> 
> 
> --
> -------------------------------------------------------
> J. Scott Johnson
> Ookles launches 2/28/06 - have you signed up yet?
> new startup: http://ookles.com/
> blog: http://fuzzyblog.com/
> podcast: http://techwarstories.com/
> fuzzygroup at gmail.com
> aim: fuzzygroup
> cell: 857 222 6459
> -------------------------------------------------------
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers