massive performance difference same filters dataverse old app new app

(0) Share

Report

Posted on by HansHeintz

622

Hi,

I have an app i have been working on since 2019.

The app uses dataverse tables and I often do collections of (filters on) tables.

Just for testting I started a new app in which I ran the same code (collection data from tables) as in the new app and discovered that in the old app it took 2 minutes and in the new one 4 seconds.

I started transplanting (copy paste code) some key components from old to new and all database actions are much faster.

I now that there once was a setting concerning dataverse speed which somehow is not visible in my settings.

My app is rather big so remaking the whole app would take weeks.

Does anyone know of a way to get my old app to communicate as fast with dataverse as the new app?

Categories:

General Questions

Connecting to Data

All responses (3)

Answers (1)

Verified answer

timl 32,024 on at

Like (1)

Report

massive performance difference same filters dataverse old app new app

Hi HansHeintz

The difference in speed could be due to the 'explicit column selection' setting. Was this disabled in your original app, as this could explain the 2min load time?
HansHeintz 622 on at

Like (0)

Report

massive performance difference same filters dataverse old app new app

@ronaldwalcott You mean if my authoring version differs from the one you are showing? (Since it doesn't)
ronaldwalcott 1,058 on at

Like (0)

Report

massive performance difference same filters dataverse old app new app

The first thing you can probably try is making a copy of the app, change the authoring version, publish and test