| |
| Publicado el 07,marzo 2018 - 10:47 |
I can't find any help related to this. So stupid but what is the maximum size (or characters) a Text Memo field can hold?
Thx |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 10:57 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 11:00 |
Thx. Exactly what I needed.
Annoying when you type Memo into Help and nothing relevant appears. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 11:25 |
Hi John,
Quote
John Fligg
I have a String 5000 field and wondered if it would be more efficient to declare it as a Memo. I know it adds an extra file (.mmo) so makes the data swell but ...
It's the exact contrary... it will make the data SHRINK... instead of having 5000 bytes mostly wasted for EACH record of your file, you will have 8 bytes in the main record (the pointer) and only the real size of your string in the memo...
as a result, the DB footprint will be much smaller.
Futhermore, if you don't NEED the memo content, you don't have to read it (you can switch memo on and off), which speeds data access.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 11:27 |
How do you switch it on and off Fabrice? I never heard of that.
Thx |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 11:43 |
Hello John
Because the memo (.MMO) is a file it is an "H" command so that makes looking in the help a little easier.
HSetMemo()
The answer to your first question is in the help under "Limits of Windev"
Regards
Al |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 11:51 |
Thank you. Wow never come across that in the years I have been using Wx.
But where do you put this? At the start of the app, during the connection, opening the form?
Sorry if I am being thick! Thx again. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 12:03 |
Hello John
As Fabrice suggested, you turn it off before reading a file if the process did not require the data in the memo file and then turn it back on when the process has finished. So before a query or a While not Hout() loop through a large file.
I don't bother as my database does not have any memo fields in files with high record counts.
Regards
Al |
| |
| |
| | | |
|
| | |