Last modified: 2014-11-01 00:55:58 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T66696, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 64696 - Store all three uuid forms(binary, alphadecimal, timestamp) instead of converting on demand
Store all three uuid forms(binary, alphadecimal, timestamp) instead of conver...
Status: RESOLVED WONTFIX
Product: MediaWiki extensions
Classification: Unclassified
Flow (Other open bugs)
unspecified
All All
: Normal minor (vote)
: ---
Assigned To: Nobody - You can work on this!
: performance
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-05-01 03:38 UTC by Erik Bernhardson
Modified: 2014-11-01 00:55 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Erik Bernhardson 2014-05-01 03:38:01 UTC
on demand conversion has shown to be an expensive operation.  In a separate topic also about uuid storage springle mentioned possibility of storing the binary version for usage in indexes and storing the additional forms unindexed but also in the table. I think this should be done at the database level rather than just in the cache to reduce the penalty users see when loading older un-cached content.

This is not incredibly urgent, we have a patch already that optimizes away most* of the conversions as long as the content is already in cache. 

* all timestamps in the output currently require uuid conversion
Comment 1 Erik Bernhardson 2014-11-01 00:55:58 UTC
After some reworking in the uuid class, these don't seem to be a perf issue anymore.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links