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 < mbsoftwaresoluti...@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] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/caamusvjd5fb5v9atnm2qobzs7+nexy1v-d53id+szv0flts...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
