I’d really appreciate if anyone can help me with this.
I’m working on a news portal site. The site is rather big, at the moment having over 200k articles. Recently the site started crashing, the problem being a very slow query that seems to be created by pdopage.
Is there some other extra that I can use for pagination that would work for large sites? Or what else could I do to fix it.