This blog originally appeared on handsetdetection.com and may not relate directly to 51Degrees.
This week we’ve completed an overhaul of our device detection rule set. The change makes our detection tables 25% smaller which results in a 15% to 25% performance improvement. Updates are live now and apply to all HD3 and HD4 customers. The optimization came about for work we’re doing on HD5.
Under the hood we’ve begun a database migration from MongoDB to Posgtres for our operating core. Migrating from NoSQL to SQL essentially means re-writing large amounts of the database backend (ouch), however it also provides a great opportunity to revist the way we do things.
So far we’ve ported our rule inspection system and the results are amazing. The Postgres trigrams module allows us to query for rule fragments in near real time on hundreds of millions of http user-agents and device build identifiers. This new capability has enabled us to ship these improvements this week.
We’ve got our eyes on a few more improvements as well in the lead up to HD5, so watch this space.
Happy Detecting :-)
Photo by Alejandro Escamilla on Unsplash