I like Charlie's idea.
But am I mistaken - wasn't there at some point a utility to kinda Zip memos & Unzip on the fly???
-K-
On Mon, Oct 5, 2020, 1:59 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 10/5/2020 2:30 PM, Charlie wrote:
<snipped> Or, create additional tables, 1 memo field each (assuming your 8 memo fields hold roughly equivalent amounts of data). Then link them back to the main table - aka main tables primary key. Of course, this would impact your data queries when pulling data. And if you really need all 8 memo fields every time you pull data, this approach will probably hurt performance (8 joins - very fast, but not as fast as pulling from 1 table).
I sometimes think the "penalty" for such an approach is negligible. Anyone have experience on that? I mean, if you get results in 1.5 seconds compared to 1.2 seconds....is that really a big deal? Even 8 seconds vs. 7 seconds. You get my drift.
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]