QuickBase Resources - upgradehttp://quickbase.intuit.com/developer/taxonomy/term/222/0
enHow can I manage my application's tables?http://quickbase.intuit.com/developer/knowledge-base/how-can-i-manage-my-applications-tables
<p>Table size can significantly affect
QuickBase performance, including the speed with which QuickBase searches
tables and runs reports.&nbsp; &nbsp;We recommend that you
schedule regular reviews of your applications to see how much storage space
each table is using and whether you can tweak your tables to optimize
performance. For
tables that are using a large amount of storage space, consider reducing table
size by moving data either up into a master table or down into a detail table,
or by removing unused fields.&nbsp; In some situations, you may find it useful
to institute a strategy for archiving older records.&nbsp; </p><p>
<strong>Note:</strong>&nbsp; Consider documenting the structure of your application
so that you have a record of each table’s and field’s purpose that you can use
when reviewing your application. You can create an Application Page with this information (To learn how, please see our <a href="https://www.quickbase.com/user-assistance/default.html#creating_a_text_page.html" rel="nofollow">Create a Code Page</a> help topic), or use one of the tools created by our <a href="http://quickbase.intuit.com/partners" target="_blank" rel="nofollow">QuickBase partners</a>.</p><h2>Monitoring Storage Space Usage</h2>
<p>To see how much storage space each
table is using, select <strong>Settings</strong> from the app's home page and click <strong>App management</strong>.&nbsp; Click the <strong>Show app statistics</strong> link.</p><p>If you are the billing account
manager, you can also see how much storage space each table is using by
clicking the <strong>Manage my billing account </strong>link
on the My Apps page and selecting an application on the <strong>Apps</strong> tab.</p><p>
<strong>Note: </strong>Although<strong> </strong>the
Application Statistics page shows you the amount of attached file space used by
each table, file attachments count towards your billing account limits, not
your table size limits.&nbsp; Like all fields, File Attachment fields themselves take up table space, but the uploaded files
do not. Deleting file attachments won't decrease your table size. (If you
notice you're getting close to your billing account’s attached file space
limit, you can use the File Attachment Management page to identify large files
and to delete unused file revisions. (To learn more, please see our <a href="https://www.quickbase.com/user-assistance/default.html#managing_file_attachments.html" rel="nofollow">Managing an Application's File Attachments</a> help topic)</p><h2>Optimizing Application Performance</h2>
<p>When reviewing your tables to optimize performance,
consider the following points:</p>
<ul><li><p>If you have a large table that serves many functions, consider
breaking the table into multiple, related tables. You then can leverage Lookup
fields, Formula fields, Summary fields and Report Link fields to run reports
containing data from the related tables.&nbsp; These fields do not affect table
size. To learn more, please see our <a href="https://www.quickbase.com/user-assistance/default.html#transform_column_into_table.html" rel="nofollow">Convert a Field into a Table</a> and <a href="https://www.quickbase.com/user-assistance/default.html#about_relationships.html" rel="nofollow">About Relationships</a> help topics.<br /><br />
<img src="http://quickbase.intuit.com/developer/sites/default/files/images/manage%20tables%202.png" alt="" />
</p></li></ul><ul><li><p>Large tables can result in many unused and dormant
fields.&nbsp; Unused fields still take up storage space.
(To learn more, please see our <a href="https://www.quickbase.com/user-assistance/default.html#field_types.html" rel="nofollow">About Field Types</a> help topic)&nbsp; To help identify
fields in use, compare the list of fields in the
table to the fields that appear on the table’s current forms. If your table
contains fields that are not used on any forms, or that are empty in a majority
of records, those fields may not be necessary for your application.&nbsp; </p></li><li><p>Review your table’s records for repeat data.&nbsp; Repeated
data can be ‘normalized’ by creating a separate master table that stores this
data once, and references it in details records as many times as you like with
no storage impact. For example, if your Contacts table repeats the same town,
state, and zip code in many records, you could create a table to store town
information and create a relationship to the Contact table. </p></li><li><p>Look for logical ways to segment your data, such as by years.
&nbsp;You can create separate tables for each of the last few years and export
that data into their respective years (2009, 2010, 2011, etc.).&nbsp; This
option has the benefit keeping your data active and close while dramatically
reducing the storage space used by table. </p></li><li><p>Wherever possible, consider how you can use Lookup
fields, Formula fields, Summary fields and Report Link fields.&nbsp; These
fields don't affect table size and allow you to run reports containing data
from multiple tables. </p></li><li><p>If your table contains large multiple-choice dropdown
fields, consider converting these fields to a master table. This not only saves
table space but it also reduces your overall application storage space.</p></li><li><p>If your table contains multi-line text fields that are set
to append only, consider converting those fields to detail tables.&nbsp; The
data is still displayed in embedded reports for the master table, but the
master table uses less storage space.&nbsp; </p></li></ul><h2>Archiving Data</h2>
<p>If you're
interested in archiving your data, you can:</p>
<ul><li><p>Move the data to another QuickBase application using the <strong>Import into a table from another table</strong>
option. To learn more, please see our <a href="https://www.quickbase.com/user-assistance/default.html#import_from_table.html" rel="nofollow">Import Data from Other QuickBase Applications</a> help topic.</p>
</li><li><p>Archive data using <a href="http://quickbase.intuit.com/developer/knowledge-base/how-would-i-automatically-download-quickbase-tables-and-their-attached-files-using-microsoft" target="_blank" rel="nofollow">QuickBase
Desktop</a>.</p></li><li><p>Contact one of our <a href="http://quickbase.intuit.com/partners" target="_blank" rel="nofollow">QuickBase
partners</a> to learn about their products for
moving data to another storage location.</p></li></ul>
<h2>For Additional Help</h2><p>Please submit a support case if you
would like help determining the best strategy for managing your
applications.&nbsp; You can enter a support
case from any application page by clicking <strong>Help </strong>on the Global bar.<strong> </strong>From there you can click<strong> Manage Support</strong> <strong>Cases </strong>and clicking the <strong>+ New Support Case</strong> button.</p>
<p>Our support team also can help match
you with a <a href="http://quickbase.intuit.com/partners" target="_blank" rel="nofollow">QuickBase partner</a>
specializing in application development and performance tuning. </p>http://quickbase.intuit.com/developer/knowledge-base/how-can-i-manage-my-applications-tables#commentsShow Application Statisticscritical alerterrorlimitlimitationlimitsmanageplanreachedsizespacetableupgradeWed, 14 Dec 2011 14:50:10 +0000quickbase3187 at http://quickbase.intuit.com/developerWhat does this error mean? "Table Size Limit has been Reached."http://quickbase.intuit.com/developer/knowledge-base/what-does-error-mean-table-size-limit-has-been-reached
<p>This error indicates that you've taken up all the storage space for a particular table.&nbsp;In order to keep the "quick" in QuickBase, tables have a maximum size limit.&nbsp;To see how close you are, you can check your application's statistics:</p><p>&nbsp;</p><p>1. From the Home&nbsp;page of the app, click&nbsp;<strong>Settings</strong>.</p><p>2. Under Advanced Features, click&nbsp;<strong>App management</strong>.</p><p>3. Click&nbsp;<strong>Show app statistics</strong>.</p>http://quickbase.intuit.com/developer/knowledge-base/what-does-error-mean-table-size-limit-has-been-reached#commentsShow Application StatisticserrorlimitlimitationlimitsplanreachedsizespacetableupgradeThu, 05 Feb 2009 22:15:58 +0000quickbase1981 at http://quickbase.intuit.com/developer