Comparative analysis of data reading performance from the Salesforce platform using GraphQL, REST and SOAP interfaces
Abstract
The article describes a comparative analysis of data reading from tables in the Salesforce environment using three different application programming interfaces. The popularity of the Salesforce platform and the release of the GraphQL interface on October 5, 2022 contributed to the study. No such study specifically for the Salesforce platform was found in the literature. The performance of reading data from the Salesforce platform was investigated using an automation script. For four tables containing a different number of rows, 8 types of queries were repeatedly executed using each of the three interfaces. It was found that depending on the number of rows, either REST API or SOAP API should be considered. In all cases, the lowest performance was observed while using GraphQL API.
Keywords:
Salesforce, performance, GraphQL, APIReferences
J. H. Bhatti, B. B. Rad, Databases in Cloud Computing: A literature review, International Journal of Information Technology and Computer Science 9(4) (2017) 9–17, https://doi.org/10.5815/ijitcs.2017.04.02.
DOI: https://doi.org/10.5815/ijitcs.2017.04.02
Google Scholar
L. A. B. Silva, C. Costa, J. L. Oliveira, A common API for delivering services over multi-vendor cloud resources, Journal of Systems and Software 86(9) (2013) 2309–2317, https://doi.org/10.1016/j.jss.2013.04.037.
DOI: https://doi.org/10.1016/j.jss.2013.04.037
Google Scholar
Dokumentacja interfejsów programowania aplikacji w Salesforce, https://developer.salesforce.com/docs/apis , [04.04.2023].
Google Scholar
Ranking systemów CRM dla roku 2023, https://www.pcmag.com/picks/the-best-crm-software , [04.04.2023].
Google Scholar
Dokumentacja Salesforce dotycząca GraphQL, https://developer.salesforce.com/docs/platform/graphql/references/graphql?meta=Summary , [04.04.2023].
Google Scholar
A. Quiña-Mera, P. Fernandez, J. M. García, A. Ruiz-Cortés, GraphQL: A Systematic Map-ping Study, ACM Computing Surveys 55(10) (2023) 1–35, https://doi.org/10.1145/3561818.
DOI: https://doi.org/10.1145/3561818
Google Scholar
J. Sayago Heredia, E. Flores-García, A. R. Solano, Comparative analysis between standards oriented to web services: SOAP, REST and GRAPHQL, Proceedings of the Applied Technologies: First International Conference, ICAT 2019, Quito, Ecuador (2019) 286–300, https://doi.org/10.1007/978-3-030-42517-3_22.
DOI: https://doi.org/10.1007/978-3-030-42517-3_22
Google Scholar
Oficjalna dokumentacja GraphQL, https://spec.graphql.org/June2018/ , [04.04.2023].
Google Scholar
P. Margański, B. Pańczyk, Analiza porównawcza technologii REST i GraphQL, Journal of Computer Sciences Institute 19 (2021) 89–94, https://doi.org/10.35784/jcsi.2473.
DOI: https://doi.org/10.35784/jcsi.2473
Google Scholar
P. Erlandsson, J. Remes, Performance Comparison between GraphQL, REST & SOAP, University of Skovde, Dissertation, https://www.diva-portal.org/smash/record.jsf?pid=diva2:1449837, 2020, [04.04.2023].
Google Scholar
Statistics
Abstract views: 123PDF downloads: 150
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
