<< Back to previous view |
[QB-4068] Anyway to speed up import MeasurementData*.xml
|
|
Status: | Open |
Project: | QuickBuild |
Component/s: | None |
Affects Version/s: | 14.0.2 |
Fix Version/s: | None |
Type: | Bug | Priority: | Major |
Reporter: | Bin Wu | Assigned To: | Robin Shen |
Resolution: | Unresolved | Votes: | 0 |
Remaining Estimate: | Unknown | Time Spent: | Unknown |
Original Estimate: | Unknown |
Description |
Anyway to speed up import this data?
Current our QB system need to longtime for upgrade I can understand export XML and import XML process will make upgrade more safe, but for the large data it almost need spend 5 hours to upgrade our system anyway to speed up the system upgrade from 13.0.41 to 14.0.2 |
Comments |
Comment by Robin Shen [ 15/Jan/24 11:26 PM ] |
Measurement data is used to show cpu/memory/network usage history. You may consider to truncate them before upgrade if that history is not important to you.That will speed up the process a lot. |
Comment by Bin Wu [ 16/Jan/24 02:23 AM ] |
Thank you for point this, but where to restrict/cleanup it?
I couldn't find from the Document, it just support the query |
Comment by Robin Shen [ 16/Jan/24 04:43 AM ] |
You may open your database with sql command line utility, and truncate data in all tables with name starting "QB_MEASUREMENTS_" |