Symbian3/SDK/Source/GUID-F5B0FE6A-6DE6-56B5-89A5-684CD2602B40.dita
changeset 7 51a74ef9ed63
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Symbian3/SDK/Source/GUID-F5B0FE6A-6DE6-56B5-89A5-684CD2602B40.dita	Wed Mar 31 11:11:55 2010 +0100
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
+<!-- This component and the accompanying materials are made available under the terms of the License 
+"Eclipse Public License v1.0" which accompanies this distribution, 
+and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
+<!-- Initial Contributors:
+    Nokia Corporation - initial contribution.
+Contributors: 
+-->
+<!DOCTYPE concept
+  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
+<concept id="GUID-F5B0FE6A-6DE6-56B5-89A5-684CD2602B40" xml:lang="en"><title>Implementation
+limits</title><shortdesc>This document lists the maximum number of tables, columns, indexes
+and so on per database.</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>
+<p>The number of tables in a database is limited only by available resources.</p>
+<p>The number of columns in a table is usually limited by a maximum record
+size of 8200 bytes (just over 8Kb), e.g. a table could have 64K not-null <codeph>Bit</codeph> columns,
+32 <codeph>Text8[255]</codeph> columns, 100 <codeph>Text8[80]</codeph> columns,
+or 32 <codeph>LongText8</codeph> columns. </p>
+<p>Each table can have up to 32 indexes. Index keys can contain any number
+of key columns, but the total size of the key must not exceed 248 bytes for
+unique indexes, and 244 bytes for non-unique indexes.</p>
+<p>The number of rows in a table is practically limited by available resources.</p>
+<p>The maximum size of a transaction is limited by available memory.</p>
+<section id="GUID-02B71501-420B-4CAA-B2D0-7490BBD5432E"><title>See also</title> <p><xref href="GUID-47419CFB-163D-5A4E-8A00-C73773353BDF.dita">Column
+type characteristics</xref> and <xref href="GUID-785B2F0B-E7E6-5DAE-98F1-6C32BED25964.dita">Database
+storage overhead</xref>.</p> </section>
+</conbody></concept>
\ No newline at end of file