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

[Jacob]

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....
>
> 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
>   
If that is the case, then let the mass WordPress PHP Extension writing 
commence. It would go a lot quicker if more people worked on it. Anyone 
know C/C++ really well?

There is only such much you can do userland to improve performance, 
without using Opcode caching. If you were to say, take that chunk of FOR 
loop and write it in C/C++, it would be that much faster. However, I 
would advise to keep SQL and database connections in userland as once 
you like compile something, it is extremely difficult to upgrade that 
something, as oppose to just dropping in new files over the old 
uncompiled ones.

-- 

Jacob Santos

http://www.santosj.name - blog
http://wordpress.svn.dragonu.net/unittest/ - unofficial WP unit test suite.

Also known as darkdragon and santosj on WP trac.