Changeset 622

Show
Ignore:
Timestamp:
03/20/08 14:42:45 (8 months ago)
Author:
areski
Message:

add caching on API ratecard

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/1.3/A2Billing_UI/api/display_ratecard.php

    r593 r622  
    4040$FG_DEBUG = 0; 
    4141 
    42  
     42$caching_query = 300; // caching for 5 minutes 
    4343 
    4444getpost_ifset(array('key', 'tariffgroupid', 'ratecardid', 'css_url', 'nb_display_lines', 'filter' ,'field_to_display', 'column_name', 'field_type', 'browse_letter', 'prefix_select', 'page_url', 'resulttitle', 'posted', 'stitle', 'current_page', 'order', 'sens', 'choose_currency', 'choose_country', 'letter', 'searchpre', 'currency_select', 'merge_form', 'fullhtmlpage')); 
    …… 
    224224 
    225225$instance_table = new Table($FG_TABLE_NAME, $FG_COL_QUERY); 
    226 $list = $instance_table -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, $order, $sens, null, null, $FG_LIMITE_DISPLAY, $current_page*$FG_LIMITE_DISPLAY); 
    227  
     226$list = $instance_table -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, $order, $sens, null, null, $FG_LIMITE_DISPLAY, $current_page*$FG_LIMITE_DISPLAY, NULL, $caching_query); 
     227        { 
    228228$country_table = new Table("cc_country","countryname"); 
    229229$country_list = $country_table -> Get_list ($DBHandle); 
    …… 
    231231$QUERY="SELECT count(*) from $FG_TABLE_NAME WHERE $FG_TABLE_CLAUSE"; 
    232232 
    233 $list_nrecord=$instance_table->SQLExec($DBHandle,$QUERY,1); 
     233$list_nrecord=$instance_table->SQLExec($DBHandle,$QUERY,1,$caching_query); 
    234234$nb_record = $list_nrecord[0][0]; 
    235235 


Google