MySQL Hosting : A little restructuring needed?

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by Nyna 0n 29 November 2008

I have been asked to look at a rather peculiar (web page) tracking system which has two parts. One tracks people by IP address as they view pages (Visitors), and another which tracks people by IP address as they view a totally different set of pages (Clients).

My job is to match the two together – by IP

Given that my external code often extracts more than one IP address from an individual hit, I have constructed an Addresses table which stores uses a CRC32() of the IP Address (a comma separated list in fact) which also permits faster insertion:

Incoming data is :
* $ip_list — a comma separated list of IPv4 addresses
* $user_id — a simple integer value

Learn more about MySQL databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting