[WB20] hyperfile sql memo file size

Startbeitrag von PETER ZHOU am 03.09.2016 07:15


Is there anyway to use code in webdev to reduce the memo file size ?
and not using WDOptimizer (as it's need to stop the hyperfile server and database connection).




Hi Peter,

in webdev, just like in anything else, you can do it by code:
- you create a second file like your first one (halias+hanchagedirectory/connexion)
- You read from the first file and write in the second. This will "delete the holes" in the memo file
- You then delete the original file and rename the second file with the name of the first one


Of course, it's much more complex if your users are writing in the memo file during that time...
And you will have to close the files at the appropriate times.

FYI: this is the old/tested method we were using BEFORE they added that option in their utility

Best regards

von Fabrice Harari - am 03.09.2016 11:46
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.