Being able to determine what searches are being performed and the number of results returned can be used to measure site usage and usefulness. The following table is now updated on every search:
id bigint(20) //entry if
searchtime timestamp // the time of the search
ip varchar(40) // the IP address of the endpoint
lat float(10,6) // the latitude of the search location
lng float(10,6) // the longitude of the search location
searchstring varchar(256) // what the user typed in the search box
query varchar(1024) // the db query issued to perform the search
numentries int(11) // the number of locations returned
Being able to determine what searches are being performed and the number of results returned can be used to measure site usage and usefulness. The following table is now updated on every search:
id bigint(20) //entry if searchtime timestamp // the time of the search ip varchar(40) // the IP address of the endpoint lat float(10,6) // the latitude of the search location lng float(10,6) // the longitude of the search location searchstring varchar(256) // what the user typed in the search box query varchar(1024) // the db query issued to perform the search numentries int(11) // the number of locations returned
Next step is to implement the report