DOI: 10.18178/wcse.2019.06.103
Improving SQL Query Response Time thru Client Side Processing in Client-Server Environment
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.