Experience working with MSSQL or MySQL to query databases

Sam Hardy | Sunday, March 22nd, 2020

HEE had a number of MySQL databases covering TIS.

Our team leveraged his significant experience of querying databases:

-Created SQL scripts to manually load National Insurance numbers into TIS.

-Used custom SQL queries to identify process issues in current ESR code.

-Wrote comparison SQL script for pilot testing.

-Helped HEE staff troubleshoot SQL issues.

-Conducted Neo4J (Graph Database) PoC; improving slow query performance on main TIE pages.

This resulted in National Insurance number load reduced manual work for approx 50,000 rotations. PoC reduced the runtime of a query from ~15 seconds to under 400ms on a low powered machine.


Filed under: Clients, Solutions