RohitPatel9999 wrote:
Q1. Need to know if there is maximum limit for record size ?
Q2. What are the consequence of using such large record size ? I may need
large record size in two-three tables.
In two or three of my tables, I may need to have 64 columns or more and
maximum record size may reach to approx. 2 MB. for some records if user
fills data fully in all columns. I am using column types INTEGER, REAL, TEXT
only (as shown in sample table below). Not using BLOB in any column of
table. (SQLite 3.3.4, Win32)
Rohit,
I believe the maximum record size is 2^31 bytes. That is also the
maximum size of a VARCHAR field (regardless of the limit specified in
the create statement).
You may want to move all the fields that you intend to search or sort on
to the beginning of your create statement. Sqlite stores the first 240
bytes (or so) of each record directly in the btree used for the table.
The rest of each large record is stored in a linked list of overflow
pages. Since it takes time to scan the overflow chain to get the value
of fields stored there, it is slower to search for those values. I
believe sqlite orders fields in the records in the same order they
appear in the create statement.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------