<< Back to previous view

[QB-4068] Anyway to speed up import MeasurementData*.xml
Created: 15/Jan/24  Updated: 02/Dec/24

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_"
Comment by Steve Luo [ 02/Dec/24 01:30 PM ]
You can backup database with "Exclude Measurements" option ticked so there is no measurements data in XML.
Generated at Tue Dec 09 12:11:06 UTC 2025 using JIRA 189.