Solved Running Dialogbox hugely affects childtable performance

Post found bugs and possible workarounds.
Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Running Dialogbox hugely affects childtable performance

Post by Dave Rabelink » 01 Sep 2017, 11:11

This defect has been registered as:
Ticket # 3281218: Running DialogBox hugely affects childtable performance

We have seen that in our running applications that childtable populate is very slow compared to pre-TD7 applications.
Simple testcases to compare the TD versions did not find the cause until now !!!

We have found that when a dialogbox is open, all childtables in the application, even located on different forms, will populate data more slowly. This impact is for each running dialog instance.
So having 2 dialogs will decrease populate performance more. Having more and more dialogs will in the end make childtables so slow that it is really unusable.

See testcase:
  • Run the sample
  • Enter the total number of rows to populate in the table (5000=default)
  • Press EXECUTE
  • See the timing result in the datafield (in milliseconds)
Now press the Create dialog button. It will create a simple modeless dialog without childs and any code.

Redo the testcase by pressing EXECUTE.

See that the time has increased to populate the table.

To see the impact, press Create dialog button many times to have multiple dialogs present in the running application.
See that for each dialog added, the performance decreases more and more.

I tested it in TD 7.0.2 and the 7.0.3 beta and both versions show the issue.

The testcase is saved in TD61 format so can be tested from TD61 up to TD70.

ChildTable_Dialog_Issue_TD61.zip
You do not have the required permissions to view the files attached to this post.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: Running Dialogbox hugely affects childtable performance

Post by Dave Rabelink » 14 Sep 2017, 08:37

Great news on this issue.
It will be solved in the upcoming TD 7.0.3 release. Testing the beta shows that the defect is solved.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

efarina
France
Posts: 5
Joined: 09 Mar 2017, 07:47
Location: Paris, France

Re: Running Dialogbox hugely affects childtable performance

Post by efarina » 14 Sep 2017, 12:13

Hi Dave,

very good news and thank you for your contribution to our small community
Best regards,

Eric Farina
Research and Development deputy Director
www.aareon.fr

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: Running Dialogbox hugely affects childtable performance

Post by Dave Rabelink » 20 Sep 2017, 11:24

This defect has been fixed in TD 7.0.3.
(But unfortunately not mentioned in the list of fixes).
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Bug Reports”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests