Re: ipblocks table available
Aaron Schulz <jschulz_4587 <at> msn.com>
2007-11-05 22:35:45 GMT
Don't forget ipb_deleted. Eventually that should require Oversight access to view things flagged with that.
-Aaron Schulz
> Date: Mon, 5 Nov 2007 16:57:13 -0500
> From: gmaxwell <at> gmail.com
> To: toolserver-l <at> 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 <at> lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare!
Try now!
<div>
Don't forget ipb_deleted. Eventually that should require Oversight access to view things flagged with that.<br><br>-Aaron Schulz<br><br>> Date: Mon, 5 Nov 2007 16:57:13 -0500<br>> From: gmaxwell <at> gmail.com<br>> To: toolserver-l <at> lists.wikimedia.org<br>> Subject: [Toolserver-l] ipblocks table available<br>> <br>> I have created a view for the ipblocks table. This view hides private<br>> data related to autoblocks.<br>> <br>> There were two possible ways that I could have created this view. I<br>> could have created so that it hides all autoblocks, or I could have<br>> created it so that it only hides the private data in autoblocks.<br>> <br>> The second choice is obviously more flexible, but it prevents the use<br>> of indexes on the ip address columns (ipb_address, ipb_range_start,<br>> ipb_range_end).<br>> <br>> Because the ipblocks tables are fairly small (even on large projects<br>> like enwiki) and because some tools already do things with autoblocks,<br>> I have decided to choose this slower option.<br>> <br>> If we have performance problems related to this view, I will change<br>> the it to the first type without any autoblocks, and potentially<br>> provide a second autoblocks only view for tools that need to see the<br>> autoblocks.<br>> <br>> _______________________________________________<br>> Toolserver-l mailing list<br>> Toolserver-l <at> lists.wikimedia.org<br>> http://lists.wikimedia.org/mailman/listinfo/toolserver-l<br><br>Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! <a href="http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews" target="_new">Try now!</a>
</div>