Rob's tech blog...

 

GeoIp - Binary DB vs MySQL Lookups

 Recently I had to implement GeoIP lookups for a client project to determine which country user's were coming from in order to supply them locale specific content. That, in itself, is not very interesting. What really prompted sufficient interest to write this post was the difference in look up performance between the two available formats for this database.

Read the rest of this post »

Filed under: Development benchmark binary coldfusion geoip maxmind mysql optimisation performance speed
 

Don't use Query of Queries for simple datasets!

 I've just finished a whole batch of optimisation routines for an Excel import/export that had to run on our CF8 based CRM system (thanks to Ben Nadel for his amazing POI CFC). The export had a tricky requirement whereby each row (of some 56,000 rows) had n items which needed to be set according to a lookup in a link table in the DB. Rather that running each comparison as a query against the live DB (56,000 rows x 20+ items = 1,120,000 queries!) I figured I could pull the whole link table into memory using a simple query and then use Query of Queries to save a bit of time.

Read the rest of this post »

Filed under: Development benchmark coldfusion optimisation performance sql
11
To Posterous, Love Metalab