Hi Everyone anyone know why this simple query is ...
# general
a
Hi Everyone anyone know why this simple query is not performing well. Profiling query:
SELECT name, version, release, arch FROM rpm_packages;
 
U:3  C:2  M:2  F:0  D:2
  rpm_packages (1/4): utilization: 60.9 cpu_time: 1.84 memory: 23822336 fds: 4 duration: 2.517601251602173  
U:3  C:2  M:2  F:0  D:2
  rpm_packages (2/4): utilization: 76.3 cpu_time: 1.91 memory: 23826432 fds: 4 duration: 2.5212669372558594  
U:3  C:2  M:2  F:0  D:2
  rpm_packages (3/4): utilization: 75.12 cpu_time: 1.88 memory: 23826432 fds: 4 duration: 2.516049385070801  
U:3  C:2  M:2  F:0  D:2
  rpm_packages (4/4): utilization: 63.92 cpu_time: 1.6 memory: 23822336 fds: 4 duration: 2.012969732284546  
U:3  C:2  M:2  F:0  D:2
  rpm_packages   avg: utilization: 69.0 cpu_time: 1.8075 memory: 23824384.0 fds: 4.0 duration: 2.3919718265533447