Re: My memo field(s) Are Bloated......

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.