aliases should be restructured

Bug #870068 reported by m4v
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Ubuntu IRC Bots
Fix Released
High
m4v

Bug Description

In stormyfacts I'm using the same aliases of Encyclopedia, using "<alias>factoid" for mark an alias.
This is good enough when you have to find the factoid of an alias, but is a hassle if you want to do find the aliases of a factoid, and in stormyfacts is aggravated by the use of revisions, specifically you have to:

aliases = store.find(Fact.name, Not(BitwiseAnd(Fact.flags, flags.DELETED)),
                                Fact.id == Revision.fact_id,
                                Fact.rev_id == Revision.rev_id,
                                Revision.value.like("<alias>%s" % name))

And is slow, is noticeable only in the cgi page though. I'm thinking in adding a separate table for aliases.

Tags: stormyfacts
m4v (m4v)
Changed in ubuntu-bots:
assignee: nobody → m4v (m4v)
status: New → In Progress
Revision history for this message
m4v (m4v) wrote :

Raising priority, due to database changes I need to figure this out before the plugin switch.

For now, in my local branch page loading improves 3 times and code is less a hassle, but the branch is incomplete and most testcases fail.

Changed in ubuntu-bots:
importance: Undecided → High
m4v (m4v)
Changed in ubuntu-bots:
status: In Progress → Fix Committed
m4v (m4v)
Changed in ubuntu-bots:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.