[wp-hackers] SELECT DISTINCT .... ORDER BY not working....

[DD32]

Computer Guru wrote:
> On 11/21/07, Stephane Daury <wordpress at tekartist.org> wrote:
>
>   
>> Of course, having some fined tune indices bundled with the installer,
>> based on the queries the code runs (at least the major ones) and not
>> just the primary keys, would be a nice step forward being more
>> efficient with our madness right out of the box. ;-)  Let's us be a
>> bit more feature/stability minded at the code level, rather than worry
>> about performance at every corner. Then again, being attentive at the
>> latter level is always an appreciated plus.
>>
>> Stephane
>>
>>     
> Actually, my problem is with the PHP.
> MySQL is very finely-tuned on my server, and has never given me any problems
> under load - it's PHP that balks when I get slashdotted.
>
> But at any rate, I think it's *always* important to keep Performance in
> mind, because it doesn't require *not* doing or adding or changing any
> features - it just requires that you do them in a certain way, and pay
> attention to the stuff that's going on.
>
> For instance, instead of just caching SQL results, it would be a ten-fold
> performance boost to cache the results of some of the larger FOR loops in
> the code....

Isnt that what the Object cache does?
It caches the output of functions, Granted, quite a lot of the functions which are cached rely on database calls.

What do you have in mind?
The presentation loops can be cached by a caching plugin such as WP-Cache, And function calls can be cached by the object cache.

Some parts of WP can run with 0 SQL Queries once the object cache is enabled.

> Logically speaking, MySQL is compiled/native code, PHP isn't - we really
> need to give PHP performance attention to; not just MySQL.
>
> just my 2 cents.
> -CG
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers