Bug #1640
Excel exportation too slow - implement "full" and "fast" exportation
0%
Description
- It has taken too much time (about a minute or more) to complete the exportation process, even for forecasting files without much data on it. Please speed up the process.
- The waiting symbol of windows (the rounding circle) does not show up anytime: during generation of the file NOR while opening the file after successfully exported. Please include.
History
#1
Updated by Oleksii Kurasov over 9 years ago
- Status changed from New to In Progress
#2
Updated by Oleksii Kurasov over 9 years ago
- Due date set to 11/12/2015
- Status changed from In Progress to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
For me XLSX format reduced exportation time twice.
About 18 sec for Merged file 1 and 2 NOV.qtb
Please, check on your comp.
#3
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- File Test merging Nov 12 succes.qtb added
- Status changed from Resolved to Feedback
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
It is still very slow. For instance, the attached file took more than a minute. See qtb file attached.
I tested it with all other applications closed and the power cord connected.
#4
Updated by Oleksii Kurasov over 9 years ago
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
I've discovered cause of slowness. There are medicines details exportation. Export of any medicines details sheet takes about 4 sec on my laptop. There is no way to reduce exportation time, because to build a medicine detail I need to iterate over all daily consumption. Maybe it will be acceptable to implement "full" and "fast" exportation. The full exportation is exportation with medicines details, fast - only main tables and an order.
What do you think?
#5
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- Subject changed from Excel exportation too slow to Excel exportation too slow - implement "full" and "fast" exportation
- Status changed from Feedback to New
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
- Priority changed from Immediate to Normal
- Target version changed from Version 3.0 to Version 4.0
Relocate as new issue for version 4.0.
#6
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- Priority changed from Normal to Immediate
#7
Updated by Oleksii Kurasov over 9 years ago
- Due date changed from 11/12/2015 to 01/13/2016
- Status changed from New to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
#8
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- File Export slow-fast.JPG added
- Status changed from Resolved to Feedback
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
Change the labels as follow:
- "Whole data (slow)" to "All data". Without the word slow at the end.
- "Without details (Fast)" to "Without med. details (faster)"
See attached.#9
Updated by Oleksii Kurasov over 9 years ago
- Due date changed from 01/13/2016 to 01/18/2016
- Status changed from Feedback to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
#10
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- Status changed from Resolved to Feedback
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
In addition to the feedback below:
Make the dialog box "Export to Excel" be displayed immediately after users call for the exportation in the forecasting menu or icon, and not after the consistent checking as currently. Then, after user define the location and type of exportation the system would process the checking, execute the forecasting and display any warning messages when needed.
#11
Updated by Oleksii Kurasov about 9 years ago
- Due date changed from 01/18/2016 to 02/05/2016
- Status changed from Feedback to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
#12
Updated by Luis Gustavo do Valle Bastos about 9 years ago
- Status changed from Resolved to Closed
Tested and adequate (slow: 1min22sec; faster: 35sec).