Issue: Implement FOUND_ROWS

Issue Tools
- View Changes

April 25, 2010 5:33 PM

pegasus

VaultWiki Team

Implement FOUND_ROWS

Currently there are a number of duplicate queries which are only used to determine pagination for Special pages, comments, etc. These queries can be improved with (and sped up by) combinations of SQL_CALC_FOUND_ROWS and $db->found_rows().

Issue Details

Issue Number 1482

Issue Type Task

Project VaultWiki 3.x Series

Category Performance

Status Completed

Priority 2 - Fatal / Database Errors

Target Version 3.0.0 RC 2

Resolved Version 3.0.0 RC 3

Milestone VaultWiki 3.0.0

Software DependencyAny

Votes to perform 0

Votes not to perform 0

Attachments 0

Assigned Users (none)

Tags (none)

May 10, 2010 6:01 PM

pegasus

VaultWiki Team

Done for the next build. I'm hoping this lightens some of the COUNT queries, especially on the Special:Statistics page.

Reply

+ Reply

All times are GMT -4. The time now is 12:29 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Implement FOUND_ROWS

Issue Tools