We are currently storing a large amount of networking data. The
database size is over 50 Gigabytes. It also grows by 10 Gigabytes
every month.
We are looking if there is a way to speedup lookups by IP Address.
The primary key is a set of values. And the key does include IP
Address as well. Will it be more efficient to also add index on IP
Address to speedup lookups by IP?
--
Regards,
Maksim