I need to show a simple list of links which comes from an external REST service. I have tried some different approaches, but all of them has issues.
Calling the external REST service when the page loaded was too slow no matter what. So instead I added a DB on WIX and setup an API in Wix that will receive the data and put it in the DB. Then I let the external database push data to the WIX database on a schedule.
So far so good - but I got issues that I cannot resolve. What I tried so far is.
1) Using a Dataset and connect a repeater to it. This actually works fast, but there are limitations. I cannot find a way to limit the length of the strings when shown on the page ("Some long link text..."*)
2) Doing a backend module that will pull the data from the database and then on the frontend generate html and set it on a text component in onReady. This works but is very slow. It takes 3-5 seconds after the page is loaded until the database content is shown.
3) Doing a backend module that will pull the data from the database and then use a DataSet and a Repeater on the frontend, but set the DataSets data programmatically and update the repeater. It takes 3-5 seconds after the page is loaded until the database content is shown.
Can anyone guide me on how to show data from a database in a way that works fast and you can still manipulate the data before it is shown?
My WIX database only has around 2000 records, and the only thing I do when loading it is filtering on one of the columns, ordering desc by another column and limiting it to 5 results.