Using the very useful RESTful Stress Chrome application I ran a set of test on some of the webservice interface functionality.

This is definitely not rigorous nor exact, I have not controlled any of the many variables that can influence the results. I just launched the tests while I was working against a live server. None the less I understand that the results must mean something and, at least, give some orientation.

This is the general setup screen: I launched each select query 100 times after 4 warmup calls with an interval of 1 second between each call.

select * from Municipios limit 371;

select * from Municipios where related.provincias='39×332'; (which returns 371 records, so the comparison is on the same number of records of the same type)

a set of different size selects against the same server and same module