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