But you shouldn't be using a normal database for this type of query anyways - it's SLOW, because you're doing a range search
Please explain to me why databases is a bad choice for data which you wish to retrieve in ranges.
If you've clustered, stored and pre-sorted the data according to the range you wish to extract, this is probably the fastest way on the planet to retrieve the data.
Or is this simply more of that good, old MySQLism? You know, the "MySQL can't do it efficiently, so databases sucks"-mantra?
but don't do IP geolocation with MySQL if performance is of any importance to you.
If you remove the "IP geolocation with" part, I think we have a winner.
Please explain to me why databases is a bad choice for data which you wish to retrieve in ranges.
If you've clustered, stored and pre-sorted the data according to the range you wish to extract, this is probably the fastest way on the planet to retrieve the data.
Or is this simply more of that good, old MySQLism? You know, the "MySQL can't do it efficiently, so databases sucks"-mantra?
but don't do IP geolocation with MySQL if performance is of any importance to you.
If you remove the "IP geolocation with" part, I think we have a winner.