<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/performance/tt/P000004_minimizing_data" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Minimizing data storage</Title>
		<Keyword ContextSensitive="No"><Level1>
                              Valid for ERP LN FP0, FP1, FP2, FP3
                           </Level1>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">Infor ERP LN can require quite some data storage depending on the application configuration.</Paragraph>
		<GeneralSection><List><ListItemHead>Oracle</ListItemHead>
				<ListItem>It is possible to compress data within Oracle for ERP LN. For more specific information, check solution number <GUIRef href="" role="manual">225096</GUIRef>. This solution provides performance related topics which deserve special attention or are not yet published via the regular documentation. Also a solution number about compressing data within Oracle is provided here. Download the solution at: <Link href="http://www.infor365.com" role="wwwlink">http://www.infor365.com</Link>
				</ListItem>
			</List>
			<List><ListItemHead>MS SQL Server</ListItemHead>
				<ListItem>For SQL Server, the porting sets 8.4b and later will, by default, use the SQL Server <GUIRef href="" role="manual">varchar</GUIRef> type for storing string information. This can cause quite a decrease on data storage usages. For sites that have an existing ERP 5.0 or ERP LN 6.1 installation that want to move to 8.4b or later, it is highly recommended to check the technical notes of the porting set. The technical notes provide information about how to change existing tables to use <GUIRef href="" role="manual">varchar</GUIRef> instead of <GUIRef href="" role="manual">char</GUIRef> type.</ListItem>
			</List>
		</GeneralSection>
	</GeneralSection>
</ManualTopic>
