Thanks Razzak and Albert for your help Just how it shows in Forms and Reports Size ( bytes )
Mohammed Sattar Utah Group of Companies -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, November 29, 2013 2:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: knowing the size of a Table At 12:28 PM 11/28/2013, Albert Berry wrote: >Num_Rows * Row_Size + table headers in file 1. Albert, Nice math, but not quite as simple as that! However, when calculating the actual size of a table, you will have to consider the data and all references to .RB4 or .RX4 that include all BLOB data, including BIT, BITNOTE, BSTR, GUID, VARBIT, and VARCHAR data types. BIT . Holds binary data ..The default length is 1 bit ..The fixed length is 1 to 1,500 bytes BITNOTE . Holds binary data . No length is needed . The variable length is 0 to 4,088 bytes of binary data BSTR (R:BASE eXtreme 9.1/9.5 (64) Only) . Holds binary string data . String data type that is used by COM (Component Object Model), Automation, and Interop functions. Used to support Unicode in table data. ..Composite data type that consists of a length prefix, a data string, and a terminator. GUID (R:BASE eXtreme 9.5 (64) Only) . Binary global unique identifier to store unique values, which is represented as a 32-character hexadecimal string . As the GUID data type is a binary value, it will increase retrieval of data from tables for indexed columns VARBIT . Holds binary data . No length is needed VARCHAR . Holds alphanumeric data . No length is needed A new FUNCTION to dynamically calculate the "TableSize" of any given table by R:BASE Engine would be a nice enhancement in R:BASE eXtreme 9.5 (32/64) and higher ... Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
