2
1

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...
1431639
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 '17, 07:04

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1431639
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 '17, 07:24

Tomeo's gravatar image

Tomeo
162354
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 '17, 09:34

Jan%20Willem%20Vermeer's gravatar image

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

In FORMSPIDER's scheme there is a package for each datasource. The name of the package is DS_<your_datasourcedefinition_id>. Ex. if your datasource ID is 6643, the package that handles your datasource will be <formspider_scheme>.DS_6643.

You can study that package's source in order to find the information you need.

DO NOT MODIFY the source of the package, as it is generated each time you modify your datasource definition.

Hope this helped!

Cezar

link

answered 14 Dec '17, 08:06

brg's gravatar image

brg
2116
accept rate: 0%

edited 14 Dec '17, 08:09

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: 1,142 times

Last updated: 14 Dec '17, 08:09


© Copyright Gerger 2017