Date: Mon, 5 Nov 2007 16:57:13 -0500 From: gmaxwell(a)gmail.com To: toolserver-l(a)lists.wikimedia.org Subject: [Toolserver-l] ipblocks table available I have created a view for the ipblocks table. This view hides private data related to autoblocks. There were two possible ways that I could have created this view. I could have created so that it hides all autoblocks, or I could have created it so that it only hides the private data in autoblocks. The second choice is obviously more flexible, but it prevents the use of indexes on the ip address columns (ipb_address, ipb_range_start, ipb_range_end). Because the ipblocks tables are fairly small (even on large projects like enwiki) and because some tools already do things with autoblocks, I have decided to choose this slower option. If we have performance problems related to this view, I will change the it to the first type without any autoblocks, and potentially provide a second autoblocks only view for tools that need to see the autoblocks. _______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l