Showing data from a WIX database is slow

Ask the community
,
1

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.

/Kristian

2

One method I have used is to do all the database tasks in a backend module and return an array that contains the data you want to show on the page. You can sort or filter the array using Javascript code, then display it in a table rather than a repeater.