[#QB-4068] Anyway to speed up import MeasurementData*.xml

QuickBuild

Anyway to speed up import MeasurementData*.xml

Created: 15/Jan/24 10:05 AM Updated: 16/Jan/24 04:43 AM

Component/s:

None

Affects Version/s:

14.0.2

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Description

« Hide

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

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

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_"

[ Permlink | « Hide ]

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

[ Permlink | « Hide ]

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.