hi,

yes, fine tuning the queries to get the best performance is always welcome.

For production environment, I suggest to process/publish the conversion of IP to num during the import process. This way applications are not affected by the overhead.

thanks for the feedback