{{tag>category:"OpenInsight 32-Bit" author:"Don Muskopf" author:"support@sprezzatura.com" author:"Sean FitzSimons"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Estimated Data Size  OI 7.1 (OpenInsight 32-Bit) ====
=== At 06 APR 2005 05:10:57PM Don Muskopf wrote: ===
 
 
<QUOTE>
While attempting to set up a new file in Table Builder, I entered  the following for Estimated Data Size:



Estimated Number of Records:  10000

Average Size:  5500



I received the following error message: "The size of the table is too large. Please reenter estimated data size."



I'm using the universal driver. I know OI can handle file sizes larger than this, so is this a limitation of Table Builder? If so, what is the limitation and are there any implications for the benefit of "additional efficiency" that the help file mentions?



Thanks.
</QUOTE>
----

=== At 07 APR 2005 05:42AM support@sprezzatura.com wrote:  ===

<QUOTE>Are you sure those where the numbers you entered?  I've tried this on 7.01 and 7.1.1 and was unable to duplicate.



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 07 APR 2005 09:51AM Don Muskopf wrote:  ===

<QUOTE>Yes, absolutely sure. I entered 10000 records with an average size of 5500.  Using OI 7.1 and universal driver.



I have never used anything but universal driver. I know there is a bug in Table Builder for Table Attributes that reports 0 records and 0 size for files created while using the Universal Driver. This has been confirmed by Revelation. I wonder if this problem is also related to the Universal Driver?

</QUOTE>

----

=== At 07 APR 2005 01:17PM Sean FitzSimons wrote:  ===

<QUOTE>Don,



I've duplicated this.  It has nothing to do with your driver, since I got it on both the 2.1 and UD Drivers.  There is a hard coded max value of 40,000,000 when creating a new table.  The value is calculated by: NUMBER OF RECORDS * AVERAGE SIZE.



It will be fixed for OI 7.1.1.



Sean

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=379AECC6EFF2DB2985256FDB00745BEF|View this thread on the Works forum...]]