Multi-level reusable static query cache for HTML5 service workers and offline data usage

We propose caching mechanism in the form of a library named mysqlj capable of returning database results as an offline data file for further use by both server and client. The unique feature of this work & library is its transparency for developers and its versatility for use both at server and client level. The cache offloads application from querying database servers in the event valid data is available. Our tests shows a web server capable of serving 1.9 times more concurrent users than existing model. An RPI3 IoT device running our model is capable of handling 60 concurrent users/secs compared to initial value of 31. Our model advocates the idea of keeping HTML and queried data separately for further use by client browser and mobile applications. The work also contributes to existing knowledge by providing an insight on performance gain and advantages while working with HTML + data separation compared to traditional mixed one.