It is not recommended to use ORDER BY RAND() only, it will slow for query large database like over 50,000 rows. The easiest way to optimize existing code, just add RAND()< (SELECT ((1/COUNT())10) FROM Table_name) after the WHERE before the ORDER, this sub query will speed up the select random from the table. Using this […]
Optimize MySQL order by RAND() Read More »
I’ve got the error by using IITC for Ingress today IITC failed to extract the required parameters from the intel site This can happen after Niantic update the standard intel site. A fix will be needed from the IITC developers. [code lang="javascript"] var reVersion = new RegExp(‘[a-z]=[a-z].getData();[a-z].v="([a-f0-9]{40})";’); var reVersion = new RegExp(‘[a-z].v="([a-f0-9]{40})";’); var minified =
ERROR: IITC failed to extract the required parameters from the intel site Read More »
