The data type used to manipulate and store data has a significant impact on memory consumption, the processor power needed to manipulate the database — both at the application server and browser (manipulation using JavaScript) level — and on the storage space needed.
Picking the wrong data type:
- wastes memory (e.g. if you store all small data in a column designed to store large amounts of data) - causes performance issues (it will be quicker to search for a number than a character string)

Ideally, you should analyze a representative data sample and use this information to decide the data type and sizing.

Modifying the DOM (Document Object Model) as you traverse it risks making the loop highly resource-expensive, especially in terms of CPU usage. An infinite loop, which consumes a huge amount of resources, might be generated if we add elements at the same time as we traverse it. It is thus highly recommended to NOT perform such edits.