Skip to main content

I have a table with about 2M records and 70 fields. I have a done a lot of optimizations to speed the visuals up and things are working pretty well. The issue is I have some fields that are pure text that altogether equal about 7000 characters. So far I have kept those fields out of the data for speed. My thought is to keep them separate and blend on a key. Will I see any speed difference with this or is the recommendation to keep them in the original table? Is this a bad idea? Any thoughts would be appreciated.

2 Antworten
  1. 14. Nov. 2023, 15:59

    Peter,

     

    Thank you for the info. To be clear we do calculations on the main database. I am hoping the blended database with the large text fields will not affect the speed or would we be better off keeping the large text fields in the main database.

     

    Thank you

    Bennie