View Revisions: Issue #6444
Summary | 0006444: Improve how bulk loader flag is set and how bulk loaded percentage is calculated | ||
---|---|---|---|
Revision | 2024-10-03 12:58 by elong | ||
Description | There are cases where a batch's bulk loader flag gets set even though the batch was processed without using the bulk loader. This can happen if the batch is a setup or finalize batch, or if the batch contains 0 rows. The bulk loader flag should not be set for setup or finalize batches, and maybe not for empty batches either. A user got confused that setup and finalize batches showed bulk loaded, but bulk command was actually failing for data batches, so there was a percent of batches showing bulk loaded, when it should have said 0%. On the Manage Outgoing Loads screen and the Manage Incoming Loads screen, the Bulk Loaded column displays the percentage of batches that were bulk loaded. When calculating this percentage, only data batches should be included. Also, if we change the bulk loader flag to instead be false for empty batches, it would probably be best for this column to display the percentage of rows that were bulk loaded instead of batches. Changes to make: 1. setup and finalize batches: don't use these batches in percent calculation; gui should show blank for bulk load flag 2. empty data batches: gui should show blank for bulk load flag 3. gui should show blank for bulk load flag for data batches until status=OK or error_flag=1 4. sym_table_reload_status: add bulk_row_load_count and use rows for the percent calculation |
||
Revision | 2024-10-02 18:01 by elong | ||
Description | There are cases where a batch's bulk loader flag gets set even though the batch was processed without using the bulk loader. This can happen if the batch is a setup or finalize batch, or if the batch contains 0 rows. The bulk loader flag should not be set for setup or finalize batches, and maybe not for empty batches either. A user got confused that setup and finalize batches showed bulk loaded, but bulk command was actually failing for data batches, so there was a percent of batches showing bulk loaded, when it should have said 0%. On the Manage Outgoing Loads screen and the Manage Incoming Loads screen, the Bulk Loaded column displays the percentage of batches that were bulk loaded. When calculating this percentage, only data batches should be included. Also, if we change the bulk loader flag to instead be false for empty batches, it would probably be best for this column to display the percentage of rows that were bulk loaded instead of batches. 1. setup and finalize batches: set bulk load flag to false, don't use these batches in percent calculation; gui should show blank 2. empty data batches: set bulk load flag to false; gui should show blank 3. sym_table_reload_status: add bulk_row_load_count and use rows for the percent calculation |
||
Revision | 2024-05-22 17:59 by emiller | ||
Description | There are cases where a batch's bulk loader flag gets set even though the batch was processed without using the bulk loader. This can happen if the batch is a setup or finalize batch, or if the batch contains 0 rows. The bulk loader flag should not be set for setup or finalize batches, and maybe not for empty batches either. On the Manage Outgoing Loads screen and the Manage Incoming Loads screen, the Bulk Loaded column displays the percentage of batches that were bulk loaded. When calculating this percentage, only data batches should be included. Also, if we decide to leave the bulk loader flag unset for empty batches, it would probably be best for this column to display the percentage of rows that were bulk loaded instead of batches. |