Latest-posts shortcode slow in huge forums

[senatorman]

i use the shortcode [bsp-display-topic-index show=’15’]

with the number 15 there is a limit to show the latest posts, but to get these results it have to search all topics and post in database to get the latest.

i’ve a huge forum with 1.1 miljon posts and this takes to long (between 4 tot 12 seconds)

is there a way to make this faster

• This topic was modified 9 years, 4 months ago by senatorman.

[Robin W]

let me take a look

[senatorman]

hopely you can find a faster way to get te latest posts.

Let me know if i can help you. I can test it on my live forum.

[Robin W]

Question – if you take out the show=’15’ is it faster – not suggesting this as a solution, it will just tell me where to start looking

[senatorman]

i’ve test it with
[bsp-display-topic-index]
and it doesn’t make any change.

You can see it here.
http://opel-forum.nl/laatste-reacties/

For your info,
several pages are cached, but this url http://opel-forum.nl/laatste-reacties/ is not

[senatorman]

You can compare self with these urls

[bsp-display-topic-index show=’15’]
http://opel-forum.nl/15laatste-reacties/

[bsp-display-topic-index]
http://opel-forum.nl/laatste-reacties/

Both urls are not cached.

[Robin W]

thanks, that’s fine – it tells me that some of my settings are not interfering.

can you test

[bbp-topic-index]

against

[bsp-display-topic-index]

and tell me any timing differences

[senatorman]

Same time (8 seconds)

http://opel-forum.nl/bbp-topic-index/

[bsp-display-topic-index]
http://opel-forum.nl/laatste-reacties/

[Robin W]

ok, thanks, that shows that I’m not coding any worse than bbpress who have experts, so I suspect there’s nothing I can do – I had a look at the code when you first rasied this to see if I could work any magic. It also uses the standard wordpress function for trawling the database, so again nothing to call on.

Version 2.6 of bbpress is supposed to be faster due to some background changes, and it’s release is getting nearer, so I think I would need to wait until that comes out to see if that helps.

I am loath to code directly to the database – but it is possible to create a loop that works backward from the latest post, checks if it is a reply that meets the criteria, and then quits when it has found x matching responses- whether it would be any faster I simply don’t know, and finding out could take lots of wasted time.

[senatorman]

ok i understand.

i will thank you to listen to my problem and understand that this is BBpress core code.

i ‘ve see indeed that version 2.6 is coming, and hope that this has a good performance boost.

Thank you for your time.

[Robin W]

no problem – sorry that on this occasion I could not help