Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 4 Jahren, 4 Monaten
Letzter Beitrag:
vor 4 Jahren, 4 Monaten
Beteiligte Autoren:
Frans, GuenterP, ICI

Hcreation is faster?

Startbeitrag von Frans am 29.08.2013 13:37

Hello to you all,

In my project code (W17 Hf Classic) I had all files opened with HcreationIfNotFound.
I replaced all this code for: Project; Projectdescription; Pane : Files; Automaticly etc

What happened: I have a window which has to call 70 times a query.
Took up to 3 to 6 times as long. And of course you only see this on a slow system. So a few customers complained.
Searched with it with the profiler etc. Cost me two days. Because there where many more changes in the new version.

Just my two cents.

Antworten:

Hi Frans,

Maybe to try with optional constant: hDelayedOpening

Offcourse, if you already don't use it.
I use (hChangeCharset+hDelayedOpening)

von ICI - am 29.08.2013 13:50
Hi Frans,

imho this is much faster than HCreationIfNotFound(...) :


MyString = HListFile("MyProjectAnalysis.wdd","",hLstNormal)+CR
FOR MyI = 1 TO StringCount(MyString,CR)
MyFileName = ExtractString(MyString, MyI, CR)
IF NOT HFileExist(MyFileName) THEN
HCreation(MyFileName)
END
END



But .. I cannot see a connection to query-execution times here ... maybe, you omitted something?

von GuenterP - am 29.08.2013 14:39
Hello Guenter,

No certainly not.
It is not the hcreation itsself which is to slow. It is the execution of query's. I was realy suppriced. That is why I posted my message.
There is something in the code of Windev that slows down the query's when You use the 'Atomaticly... etc' instead of Hcreation.

I don't know why.

Regards Frans

von Frans - am 29.08.2013 16:36
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.