I am mid-way through developing a management information system and have been asked to build in functionality to allow users to input notes and summaries that may be up to two full A4 pages of text in length. There may be several dozen of these summaries.
I could use memo fields to hold this data but am a bit worried about the effect this may have on size and the performance of the database. Does anyone have experience of this?
Does anyone have any ideas about how else this might be done.
I could use memo fields to hold this data but am a bit worried about the effect this may have on size and the performance of the database. Does anyone have experience of this?
Does anyone have any ideas about how else this might be done.