techjoomla / com_api

API framework for Joomla
http://docs.techjoomla.com/joomla-rest-api/com-api-introduction
GNU General Public License v3.0
123 stars 97 forks source link

Add table index for keys.userid & keys.key #32

Closed coolbung closed 7 years ago

coolbung commented 7 years ago

On a high API transaction site, the queries for this table are running rather slow due to the absence of indexes. So indexes need to be added for the following columns in the keys table

coolbung commented 7 years ago

Added separate keys for hash and userid in the keys table. This is since the query profile hardly has both in the same query.

Index also added for hash on logs table so that the rate limiting can be made functional at some point.