WCSE 2019 SUMMER ISBN: 978-981-14-1684-2
DOI: 10.18178/wcse.2019.06.103

Improving SQL Query Response Time thru Client Side Processing in Client-Server Environment

Ruben A. Parazo, James A. Esquivel

Abstract— Queries executed by a client in the database server were profiled, managed and reused to respond to future subdued queries to be executed in the client. This technique not only reduced the number of queries to be processed by the database and the server but also contributes in decreasing the utilization of network, database and server resources because future subdued queries to be executed that are subdued from the previous executed query were responded locally. Conditions in the query were removed before sending to the database for evaluation in order to increase its effectiveness for its intended purpose. Profiled queries that are subdued by incoming query were purged including its corresponding result set while the incoming query was profiled in the repository. This was implemented as a technique to avoid storing redundant data in the repository as well as to avoid query capability duplication. Tests showed that utilization of a local repository of previous executed queries to respond to a subdued requested query decreased the latency incurred in fetching data both in small, medium and large number of records as compared to a requested query responded by a database and server where the data still travelled thru the network.

Index Terms— SQL Query, Database, Reusing Result set, Condition Elimination, Query logs, serial scanning

Ruben A. Parazo
Tarlac Agricultural University, PHILIPPINES
James A. Esquivel
Angeles University Foundation, PHILIPPINES


Cite: Ruben A. Parazo, James A. Esquivel, "Improving SQL Query Response Time thru Client Side Processing in Client-Server Environment," Proceedings of 2019 the 9th International Workshop on Computer Science and Engineering, pp. 697-703, Hong Kong, 15-17 June, 2019.