I am creating a module for which i am recording users IP address while user is browsing through the site and later on using this data to generate report as of Google analytic.
We have database that contains table like ISP,Location,Company based on various ip number ranges.
ID StartIP EndIP Organization
1021 16874455 14587965 ABC
This tables contains huge number of records (around 70-80 lacks or rows per table) and I am joining such 5-6 tables to extract various data. This query takes lots of time so i am trying to find solution on boosting the query performance.
Can any body tell me solution for this. I have already put index on columns that i used in search criteria.. mostly IP range. Any other things that should be taken in mind.