Laufzeitverhalten DBFCDX VO/X#

Deutschsprachiges X#-Forum – German language forum

Moderator: wriedmann

User avatar
wriedmann
Posts: 3753
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Laufzeitverhalten DBFCDX VO/X#

Post 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
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
User avatar
Chris
Posts: 4878
Joined: Thu Oct 08, 2015 7:48 am
Location: Greece

Laufzeitverhalten DBFCDX VO/X#

Post 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.
Chris Pyrgas

XSharp Development Team
chris(at)xsharp.eu
hsg
Posts: 10
Joined: Mon Jul 26, 2021 6:39 am

Laufzeitverhalten DBFCDX VO/X#

Post 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
Jamal
Posts: 315
Joined: Mon Jul 03, 2017 7:02 pm

Laufzeitverhalten DBFCDX VO/X#

Post 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
User avatar
wriedmann
Posts: 3753
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Laufzeitverhalten DBFCDX VO/X#

Post 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
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Post Reply