Difference between revisions of "Documentation/FAQ/Databases/Why does my table show the wrong number of records?"
(Created page with "{{DISPLAYTITLE: Why does my table show the wrong number of records?}} <section begin=question/> '''Why does my table show the wrong number of records?''' <section end=questio...") |
m |
||
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
<section begin=answer/> | <section begin=answer/> | ||
Base developers chose not to load all records for performance and bandwidth reasons. Unfortunately, they also chose to inform you of this incremental approach by displaying a count of only the loaded records. So initially, Base will report a smaller number of records than you actually have. | Base developers chose not to load all records for performance and bandwidth reasons. Unfortunately, they also chose to inform you of this incremental approach by displaying a count of only the loaded records. So initially, Base will report a smaller number of records than you actually have. | ||
| − | To indicate this, Base will show a small asterisk (*) after the record count. So a number without asterisk '''< | + | To indicate this, Base will show a small asterisk (*) after the record count. So a number without asterisk '''<tt>23</tt>''' means there are a total of 23 records in your table, while '''''<tt>23 (*)</tt>''' means there are 23 <em>known</em> records currently loaded, but there are additional unloaded records in the table/result-set. |
This record-count display philosophy is not related to performance or bandwidth considerations. Record count retrieval is instantaneous. It's a poor design, but some workarounds may suffice ([https://forum.openoffice.org/en/forum/viewtopic.php?p=105520#p105520 SubForm workaround] / [https://forum.openoffice.org/en/forum/viewtopic.php?p=223734#p223734 macro workaround]). | This record-count display philosophy is not related to performance or bandwidth considerations. Record count retrieval is instantaneous. It's a poor design, but some workarounds may suffice ([https://forum.openoffice.org/en/forum/viewtopic.php?p=105520#p105520 SubForm workaround] / [https://forum.openoffice.org/en/forum/viewtopic.php?p=223734#p223734 macro workaround]). | ||
| Line 15: | Line 15: | ||
[[Category:Documentation/FAQ]] | [[Category:Documentation/FAQ]] | ||
| + | [[nl:NL/Documentation/FAQ/Databases/Why_does_my_table_show_the_wrong_number_of_records%3F]] | ||
Latest revision as of 13:03, 1 July 2023
Why does my table show the wrong number of records?
Base developers chose not to load all records for performance and bandwidth reasons. Unfortunately, they also chose to inform you of this incremental approach by displaying a count of only the loaded records. So initially, Base will report a smaller number of records than you actually have. To indicate this, Base will show a small asterisk (*) after the record count. So a number without asterisk 23 means there are a total of 23 records in your table, while 23 (*) means there are 23 known records currently loaded, but there are additional unloaded records in the table/result-set.
This record-count display philosophy is not related to performance or bandwidth considerations. Record count retrieval is instantaneous. It's a poor design, but some workarounds may suffice (SubForm workaround / macro workaround).
