Bug 726048 - Change DB & BE from decimal to float or int
Summary: Change DB & BE from decimal to float or int
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-core
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: lpeer
QA Contact:
URL:
Whiteboard: infra
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-07-27 12:20 UTC by Eli Mesika
Modified: 2012-12-11 06:41 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-12-11 06:41:26 UTC
oVirt Team: ---
Embargoed:


Attachments (Terms of Use)

Description Eli Mesika 2011-07-27 12:20:37 UTC
Description of problem:
The following DB entities have wrong type:

vds_dynamic:
  cpu_speed_mh : decimal(18,0) => change to int
vds_statistics:
  cpu_idle, cpu_load, cpu_sys, cpu_user decimal(18,0) => change to float
vm_statistics :
  cpu_sys, cpu_user, decimal(18,0) => change to float
  elapsed_time  decimal(18,0) => change to int
vm_interface_statistics :
  rx_rate, tx_rate, rx_drop_ tx_drop decimal(18,0) => change to int
vds_interface_statistics :
  rx_rate, tx_rate, rx_drop_ tx_drop decimal(18,0) => change to int

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:
Change type in DB & BE as described above

Additional info:
Should be targeted for 3.1

Comment 1 Laszlo Hornyak 2011-09-01 14:38:17 UTC
This reduces some IO and could be a nice performance gain on the insert performance, especially on the tables with multiple decimal fields. Decimal(18) takes more space than int 4, but of course its precision is bigger as well.

For read performance: no, or minor performance gains.

Comment 2 Itamar Heim 2012-12-11 06:41:26 UTC
Closing old bugs. If this issue is still relevant/important in current version, please re-open the bug.


Note You need to log in before you can comment on or make changes to this bug.