|
| [WB20] hyperfile sql memo file size |
| Iniciado por guest, 03,sep. 2016 09:15 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 03,septiembre 2016 - 09:15 |
Hi,
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).
Regards,
PETER ZHOU |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,septiembre 2016 - 13:46 |
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
Done...
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 |
| |
| |
| | | |
|
| | | | |
| | |
|