When the number of records was increased the above methods did not work efficiently. Results revealed that processing inside the array, and the query formula, for around 10k - 15k records could be done in Spreadsheets reading. A REST API endpoint has been implemented using GAS to evaluate the reliability of writing data into databases and executed it with Apache JMeter concurrent users. Execution times were calculated by changing different parameters such as the number of records, database connection time, and array processing time. Seven experiments were carried out by using multiple algorithms to compare the reading performance such as, retrieving all values within a specified range and processing them, retrieving data using query formula, SELECT statement in Structured Query Language (SQL), Google Query Language, and joining multiple tables in the spreadsheet. The main objective of this study is to evaluate the performance of Google Spreadsheet as a database over RDBMS and compare the performance of different algorithms when reading and writing data into Spreadsheets and RDBMS. When developing systems using Google Apps Script, Developers can configure external Relational database management system (RDBMS) connections or Spreadsheets as a database. It offers built-in APIs for almost all the services offered by GSuite. Google Apps Script (GAS) is a scripting platform developed by Google for light-weight application development in the G Suite platform.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |