Performance 30000 post
We have in the database 30.000 posts , about 300 per user.
When a user login in his account and navigate with multiple pages about his posts without filter, the perfomarce is good, but when I order by 1 column, the performance down a lot. (from 1 or 2 second, to more that 10 seconds for change the page), I tested with view 10 post/page and 40 post/page with the same behaviour. Seems that is ordering all the post and then filter by user for show it. Is strange because how I say.. when not filter is or ordering is selected the navigation pages is fine.
Can you hellp me?
You must be logged in to reply to this topic.