Hi 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) Thanks Rohit /* CREATE Statement for sample table */ /* Note: VARCHAR will be TEXT in SQlite. VARCHAR and size is just used so it may work for other databases. */ create table customers ( id INTEGER PRIMARY KEY, dts REAL, /* Date Time Stamp (When record updated lastly) */ useridwml INTEGER, /* id of user who modified last (this record) */ szname VARCHAR(32), /* Customer Name */ blockstatus INTEGER, /* Locked or Not */ bactivestatus INTEGER, /* Active or Not */ bvisibilitystatus INTEGER, /* Visible or Not */ obal REAL, /* Opening Balance */ obalcr INTEGER, /* Cr or Dr Balance */ dtobal REAL, /* Date (of Opening Balance) */ szdesc VARCHAR(32), /* Description / Note / Comment */ szsalu VARCHAR(10), /* Salutation -> Mr./Ms./.. */ szfnm VARCHAR(20), /* First Name */ szmnm VARCHAR(20), /* Middle Name */ lnm VARCHAR(20), /* Last Name */ /* Bill_To Address */ sza1 VARCHAR(32), /* Address Line 1 */ sza2 VARCHAR(32), /* Address Line 2 */ sza3 VARCHAR(32), /* Address Line 3 */ sza4 VARCHAR(32), /* Address Line 4 */ szcity VARCHAR(20), /* City */ szzip VARCHAR(12), /* Zip / Postal Code */ szstate VARCHAR(20), /* State / Province */ szcntry VARCHAR(20), /* Country / Region */ /* Ship_To Address */ sz2a1 VARCHAR(32), /* Address Line 1 */ sz2a2 VARCHAR(32), /* Address Line 2 */ sz2a3 VARCHAR(32), /* Address Line 3 */ sz2a4 VARCHAR(32), /* Address Line 4 */ sz2city VARCHAR(20), /* City */ sz2zip VARCHAR(12), /* Zip / Postal Code */ sz2state VARCHAR(20), /* State / Province */ sz2cntry VARCHAR(20), /* Country / Region */ szfullnmcontact VARCHAR(32), /* Name of primary contact person */ szph1 VARCHAR(20), /* Phone Number 1 */ szph2 VARCHAR(20), /* Phone Number 2 */ szfax1 VARCHAR(20), /* Fax Number 1 */ szemail1 VARCHAR(32), /* Email Address 1 */ szwww1 VARCHAR(32), /* WebSite Address 1 */ /* Additional Info */ ltypid INTEGER, ltermsid INTEGER, dcrlmt REAL, lpricelvlid INTEGER, lnum INTEGER, szresalenum VARCHAR(20), bdoc1 INTEGER, bdoc2 INTEGER, bdoc3 INTEGER, szrep VARCHAR(20), lprefcorrtypid INTEGER, lTaxCode INTEGR, szit VARCHAR(20), szvat1 VARCHAR(20), szvat2 VARCHAR(20), szst VARCHAR(20), szst VARCHAR(20), srt VARCHAR(20), szcex VARCHAR(20), szlic VARCHAR(20), szudcf1 VARCHAR(20), szudcf2 VARCHAR(20), szudcf3 VARCHAR(20) ); -- View this message in context: http://www.nabble.com/record-size-limit-----tf2355094.html#a6559539 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
