Hello,
Do you have a recommendation or have done any testing to compare API connectors and database connectors.
For example: If I have an API method that I created in Linx that queries data from a table in a SQL database, is there a performance difference (or other advantage) between calling the API method from Stadium 6 vs implementing a database connector to do the same sql query.
Hi Irene,
both, the WebService Connector and the Database Connector perform a WebService call to the Stadium Server to fetch data. How long it takes for the server to return data does not depend on the type of Connector, but rather on the environment.
Factors that can influence how long it takes for data to be returned including the performance of the database server, the speed of the network and the amount of processing various servers are performing at the time when the call is made.