Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: topic query count in alpha 1.0 – any progress?


andersson
Participant

@andersson

Well then this problem may just be locally for me then, but when running the alpha 1.0, for a topic for instance, runing _CK_’s excellent admin tool you’ll see about 50-60 queries that does something like this:

# 51 : 0.0195 seconds
SELECT * FROM bb_users WHERE ID = '6526'

# 52 : 0.0122 seconds
SELECT meta_key, meta_value FROM bb_usermeta WHERE user_id = '6526' /* WP_Users::append_meta */

# 53 : 0.0004 seconds
SELECT * FROM bb_users WHERE ID = '5605'

# 54 : 0.0003 seconds
SELECT meta_key, meta_value FROM bb_usermeta WHERE user_id = '5605' /* WP_Users::append_meta */

# 55 : 0.0014 seconds
SELECT user_id, meta_key, meta_value FROM bb_usermeta WHERE user_id IN (365,1325,267,1088,2295,1106,94,1259,1225,1210,2230,3055,7,4566,3869,2992,1894,5690,2713,5873,6526,5605) /* WP_Users::append_meta */

As you can see, it has run over 50 queries that simply does what is done correctly in query 55 (the last query). It seems it runs this for every post it displays (I display 30 posts per page).

Like I said, maybe this is something that is just happening for me but I seem to remember someone having this problem with the first page also, but that time it was the topic meta I think.

Any help is much appreciated.

Skip to toolbar