API connector VS Database connector

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.