API Data, Bubble Database or MySql Data. Wich one?

Questions
1

Hello everyone.

I use a payment gateway where all transactions are stored.

I need to display this information in my Bubble APP in the form of graphs and tables, including being able to make queries with date filters, transaction status, among others.

I thought of 3 alternatives for that.

1- Use the webhook, where every transaction will be recorded in the Bubble database.
(this option will considerably increase the amount of data)

2- Use the webhook, where every transaction will be recorded in a MySql database and connect Bubble to access this data in that external database with the connection plugin.

3- Use the API to consult the payment gateway system itself, whenever a query or filter is applied.

(another detail, it is a multi-user system)

Having said that, what is the best way to do it?

Taking into consideration the optimization of the Bubble application, access speed and processing, use of server resources and storage.

Thanks in advance!

2

Somebody to help?

3

Since your payment gateway already host and provides an API for you to request the data, why won’t you try first the API and check if it is speedy enough for you ?

4

Agreed with @lucas.ar, else you will add processing time within your app.

5

yes, i will try first with the API.

My biggest doubt was whether querying the Bubble database itself would be faster than using an API to query an external database with millions of data.

But your answer makes sense, because the API process will happen on the server of the other platform, returning only the results. Right?

thanks for the answers