xsharp.eu • Laufzeitverhalten DBFCDX VO/X# - Page 2
Page 2 of 2

Laufzeitverhalten DBFCDX VO/X#

Posted: Fri Aug 20, 2021 6:03 am
by wriedmann
Hallo Jörg,
ich kann mir schon vorstellen, dass ein Testcase nicht ganz einfach ist.
Aber man braucht sich nur in die Rolle von Chris oder Robert zu versetzen, die mit diesen Testcases dann arbeiten müssen.
Idealerweise ist das eine Console-Applikation, die sowohl in VO als auch in X# vorliegen sollte, damit man den Unterschied sehen kann. Es kann sein, dass die Sache mit dem Index zusammenhängt (hier hat ein VFP-Kollege ein recht interessantes Beispiel geliefert), genauso wie es am FPT-Schreiben liegen kann, oder sogar im Satz-Managment beim Anlegen.
Wolfgang

Laufzeitverhalten DBFCDX VO/X#

Posted: Fri Aug 20, 2021 6:21 am
by Chris
Hi Jörg
hsg wrote: Here the relevant parts of the import (dtaBelegExchange.prg in ASBau ExImport)
Ah, sorry, it would had been easier if I had just asked you to simply point me to the relevant code in the project I already have :). From a quick look, I see that the dbfs used for importing are opened in shared mode, is that right? Can't they be opened in exclusive mode instead? This alone should give a good performance improvement.

I will look further into it, but to save me some time searching for it, can you give me some quick info on how to invoke this import mechanism in your app? What menu command to select, what actions before pressing a button there etc.. Probably better do it by private email, since this is related to the internals only of your application.

Laufzeitverhalten DBFCDX VO/X#

Posted: Fri Aug 20, 2021 6:46 am
by hsg
Chris wrote:Hi Jörg
hsg wrote: Here the relevant parts of the import (dtaBelegExchange.prg in ASBau ExImport)
Ah, sorry, it would had been easier if I had just asked you to simply point me to the relevant code in the project I already have :). From a quick look, I see that the dbfs used for importing are opened in shared mode, is that right? Can't they be opened in exclusive mode instead? This alone should give a good performance improvement.

I will look further into it, but to save me some time searching for it, can you give me some quick info on how to invoke this import mechanism in your app? What menu command to select, what actions before pressing a button there etc.. Probably better do it by private email, since this is related to the internals only of your application.
Hi Chris,
i'll send you in the next days a mail with the hints you need. I also will have a look to open the databases eclusivly

Edit: i had test now with exclusive opened databases, and the improving the speed is enormes. Same Result, when i delete a receipt.
I have to talk with Peter about this matter. Normaly the application will use in office by many peoples, so exclusive opened database maybe a problem

Laufzeitverhalten DBFCDX VO/X#

Posted: Sat Aug 21, 2021 3:44 am
by Jamal
Guys!

Scanning the code that was posted, Ed is using Append. The issue has been reported by me several months ago:

https://www.xsharp.eu/forum/public-prod ... ence#18721

This issue still exists!

Jamal

Laufzeitverhalten DBFCDX VO/X#

Posted: Sat Aug 21, 2021 3:52 am
by wriedmann
Hi Jamal,
the github ticket is open:
https://github.com/X-Sharp/XSharpPublic/issues/711
so it will not be forgotten, and as you can see, after holiday time there is some work to do on the RDD:
https://github.com/X-Sharp/XSharpPublic/labels/RDD
Wolfgang