Record the ipAddr and timestamps of the last n queries |
Query log table to record last n query IPs and timestamps so that queries can be restricted to a certain number per minute per IP to prevent crawlers from hogging the system (see spExecuteSQL). |
name | type | length | unit | ucd | description |
ipAddr | varchar | 30 | |||
lastQueryTime | datetime | 8 |