<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
The end of database-upgrade is close at hand<br>
..and there are some changes to take into account.<br>
<br>
One of them is that we can now reach/join any database from within
one single connection without caring about federation issues.<br>
Good occasion to re-check the current queries.<br>
<br>
To facilitate this job, I've written a small and easy-to-use tool:
The
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
fancy Labs SQL Optimizer<br>
<a class="moz-txt-link-freetext" href="https://tools.wmflabs.org/tools-info/optimizer.php">https://tools.wmflabs.org/tools-info/optimizer.php</a><br>
<br>
Features:<br>
- Analyses your query with EXPLAIN command (copy & paste)<br>
- Shows corresponding table definitions / indices / views at a
glance<br>
- Gives some hints and provides links to related SOL-resources on
Tools/Labs<br>
<br>
Limitations:<br>
- Limited set of data (100,000 - 600,000 records per table)<br>
- POST only, by intention<br>
<br>
Enjoy! Feedback always appreciated.<br>
<br>
-Hedonil<br>
</body>
</html>