[wp-hackers] Hacking Assignment: Paging by Days

[Sebastian Herp]

I agree with you on that :-)

41 is definitely excessive and it is only the case that i have so much 
queries, because i only imported the posts of my real blog via 
sql-export/import. The categories seem to be the problem then, causing 
this amount of queries. Everytime I edit one of the posts and give it an 
existing category the querycount decreases by one :-) i guess it would 
be 19 or 20, too, after changing all of the posts ... but going over all 
queries isn't a bad idea and could speed up wordpress just a littlebit 
more :-)

Greetings,
Sebastian

Ryan Boren wrote:

>>One thing though: this is the first time i tried out the cvs version. 
>>While i can't say it is slow, i noticed that it takes 41 queries to 
>>build up the mainpage compare to around 10 queries on a stock wordpress 
>>1.2. Why? This would slow down websites where the mysqlserver is not the 
>>the webserver, too ...
>>    
>>
>
>I get 19 queries when paging by posts and 20 when paging by days.  I
>think that is too much, 41 is definitely excessive.  It's time to go
>over our queries and make sure we are using the caches where we should
>be.  If anyone wants to do some profiling, that would be appreciated.
>
>Ryan
>
>  
>