I need to work with SQL Sever Data showing it in some WIX pages.
I have a Rest API that help me to get this data to WIX.
Now I'm importing the data to collections and I use the Collections data in the Pages where I show it.
But I wonder if it could be better to use the SQL Server data "directly", I mean without using the Collections step. If is it possible how can I do it?
There are several tables so I'll have to do the process of import data very often and it need to be as fast as possible.