View source

[[Category:Performance]]

This page gathers general information about OAR's performances and theirs enhancements.

* See: [[:Category:Performance]]
*[[Performance Evaluation 2.5]]
*[[Performance Evaluation 2.4]]
*[[Performance evaluation in virtual environment]]

*[http://evalys.imag.fr/index.php/Main_Page Evalys] a wiki with information and tools for experimental performance evaluation of computing infrastructures (upto HPC oriented)

= Generealities =
* Add default properties to job hit performance due to one request SQL against resources table fired per job (schedulers should implement SQL request result cache).

= Specifics Points=

== Use of DB indexes ==

* In ocaml-scheduler: waiting job retrieves request use several CURRENT selection in WHERE clause, not in perl schedulers

   WHERE
      moldable_job_descriptions.moldable_index = 'CURRENT'
      AND job_resource_groups.res_group_index = 'CURRENT'
      AND job_resource_descriptions.res_job_index = 'CURRENT'
      AND jobs.state = 'Waiting'
      AND jobs.queue_name =  '%s'
      AND jobs.reservation = 'None'
      AND jobs.job_id = moldable_job_descriptions.moldable_job_id
      AND job_resource_groups.res_group_index = 'CURRENT'
      AND job_resource_groups.res_group_moldable_id = moldable_job_descriptions.moldable_id
      AND job_resource_descriptions.res_job_index = 'CURRENT'
      AND job_resource_descriptions.res_job_group_id = job_resource_groups.res_group_id
      ORDER BY moldable_job_descriptions.moldable_id, job_resource_groups.res_group_id, job_resource_descriptions.res_job_order ASC;"