https://bugzilla.wikimedia.org/show_bug.cgi?id=16378
Roan Kattouw <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |WONTFIX
--- Comment #4 from Roan Kattouw <[EMAIL PROTECTED]> 2008-11-18 19:12:35 UTC
---
(In reply to comment #3)
> I've used a query like this to find out who is the creator of a given page,
> but
> that won't be of much use to find all pages started by a given user:
>
> SELECT p.page_id AS page_id, MIN(r.rev_id) AS first_revision_id, r.rev_user as
> user_id
> FROM page AS p
> LEFT JOIN revision AS r ON(p.page_id = r.rev_page)
> WHERE p.page_title = 'Title'
You'd have to repeat that query op to 5,000 times, once for every page queried.
The database servers aren't gonna like that.
> How about storing the user id of the person who made the first revision of
> each
> page right in the page table? page_first_user or so? What would the downsides
> of doing something like that be?
Such a field would be of limited use (only useful for this query and pretty
much nothing else). Also, the 'creator' of a page can change (in theory;
doesn't happen much in practice I guess), and the conditions under which that
happens aren't easily detectable. All in all, I'd say it wouldn't be worthwhile
to add such a rarely used field.
> I'll reopen this bug (just this once), to request it be marked for future
> development, because I would find this functionality useful on Wikipedia and
> also on my installation of MediaWiki.
If you really wanna go through with requesting page_first_user or another
database field or index to facilitate this feature, you should file a separate
bug for that. Closing this one as WONTFIX again.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
