Hi,

After some action a record in a panel has to be refreshed. I use api_datasource.refreshRow for this and now it appears that in some cases, this procedure takes approx 90 seconds to complete. While in other cases it finishes in a second. I have replaced it with a full requery of the specific datasource, which also finishes in a blink of the eye.

Now i would like to know why api_datasource.refreshRow is so extremely slow...

The panel is based on a datasource with a unique key. So, a requery must be fast, i guess. But probably FS does something else than a requery.

Can you explain what api_datasource.refreshRow is doing exactly so i get figure out what's going wrong here?

Kind regards, Jan Willem Vermeer

asked 10 Dec '15, 05:29

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1231434
accept rate: 0%


Hi team,

We are still running into problems with this api_datasource.refreshRow procedure. This time the problems are even more severe, because it nevers finishes and the user has to restart the application in order to proceed with his work.

Please explain to me what this procedure exactly does and why it might be this slow?

Kind regards, Jan Willem

link

answered 28 Jun, 07:04

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1231434
accept rate: 0%

We have similar problem for ages, but have no clue what's behind. It would be great if somebody from FS could explain.

link

answered 04 Jul, 07:24

Tomeo's gravatar image

Tomeo
162351
accept rate: 3%

Hi team,

what i especially need to know is what's being done to refresh the row. For example: is the datasource queried again with the original arguments? Or is only the current row queried again and is that with of without all original arguments for the datasource.

Note that it is possible that after refreshing of the row, it might NOT be anymore valid for the original arguments. So, when i requery the datasource again, the row will not be found anymore. But if the refresh only queries on the primary key, so without the other arguments, that can not be the cause.

Kind regards, Jan Willem

link

answered 04 Jul, 09:34

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1231434
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2
×2

Asked: 10 Dec '15, 05:29

Seen: 961 times

Last updated: 04 Jul, 09:34


© Copyright Gerger 2017