I'm not sure if this goes under PHP or Database
I have a database with over 100k rows of search results and tracking information.
When i try query and compile a report it takes FOREVER... is there any techniques to run faster queries ?
the database columns are
id | ipaddress | page | product | timedate | se_keywords