https://bugzilla.wikimedia.org/show_bug.cgi?id=65851
--- Comment #2 from Aaron Schulz <[email protected]> --- A few questions: a) How many rows per petition name might we aspect roughly b) Ditto per rows in the whole table (the CSV dumps this) c) Will the pages with the tags to include these be high-traffic (they are uncached and do a COUNT(*) each time? If yes, it might help to cache the count or even use a Redis hyperloglog (provided there was some de-duplication) d) Actually, why is there no de-duplication? Right now someone can keep signing it with similar names. Maybe some criteria could be established for that. That would bound how many rows one person could put into the table. e) Maybe some IP restrictions and rate-limiting could be applied. If there is no de-duplication, then that at least bounds the rate that someone can spam rows into the table (which should be done anyway). I'd suggest using User::pingLimiter. Limits must also be set in wmf-config in a separate patch. f) Relatedly, should blocked users be able to sign petitions? I see there is a $wgPetitionDatabase. It would be nice if there was a $wgPetitionCluster so it could use the same DB that Flow uses. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
