I was trying to get all the price from a pricelist by execute read to product.pricelist.item . From this read result, I got the product id and then I execute another read to product.template to get the qty_available. This can be done correctly but the performance is slow when the pricelist got 60 products , it took more than 10 seconds to complete the result. Do you have any suggestion to improve the performance? Thanks in advance, below is the code I wrote :

$ids = $models->execute_kw($db, $uid, $password,

'product.pricelist', 'search_read',

array(array(array('id', '=', $_SESSION['pricelist_id']))),

array('fields'=>array('id','name','display_name', 'item_ids', 'company_id'))

) ;

$result = $models->execute_kw($db, $uid, $password,

 'product.pricelist.item', 'read',

array($ids[0]['item_ids']),

array('fields'=>array('id','name','display_name', 'product_tmpl_id', 'compute_price', 'fixed_price', 'product_id', 'categ_id', 'pricelist_id', 'currency_id'))) ;

foreach($result as $product){

$prod_result = $models->execute_kw($db, $uid, $password,

'product.template', 'read',

array($product[product_tmpl_id][0]),

array('fields'=>array('default_code', 'qty_available','categ_id'))) ;

}