php - This page is taking too long to load -

-

i have created view page on php zend framework. view page has 10 methods. each method has 3 sql queries returning thee values. calling these 10 methods 10 times. queries working on table of 24,000 rows. it's taking 2-3 minutes load view page. storing function results in arrays , using array values display.

how can implement output caching on this?

source code view part is: variables:

$no_of_customers = array(); $no_of_customers_ee = array(); $no_of_customers_nee = array(); $unique_customers = array(); $unique_customers_ee = array(); $unique_customers_nee = array(); $no_of_sent = array(); $no_of_sent_ee = array(); $no_of_sent_nee = array(); $no_of_opened = array(); $no_of_opened_ee = array(); $no_of_opened_nee = array(); $no_of_surveys = array(); $no_of_surveys_ee = array(); $no_of_surveys_nee = array();    $promoter = array(); $promoter_ee = array(); $promoter_nee = array(); $detractor = array(); $detractor_ee = array(); $detractor_nee = array(); $passive = array(); $passive_ee = array(); $passive_nee = array();

one of function using is

function unique_customer($con,$start_date,$end_date ,&$unique_customers,$i,$customertable,&$unique_customers_ee,&$unique_customers_nee) {  $result = mysqli_query($con,"select count(distinct emailaddress) total, product $customertable  importdate >='$start_date' , importdate <'$end_date' ;"); $rs = mysqli_fetch_array($result);  $unique_customers[$i] = $rs['total']; unset($rs);  $result_ee = mysqli_query($con,"select count(distinct emailaddress) total_ee, product $customertable  importdate >='$start_date' , importdate <'$end_date' , product = '';"); $rs_ee = mysqli_fetch_array($result_ee);  $unique_customers_ee[$i] = $rs_ee['total_ee']; unset($rs_ee);  $result_nee = mysqli_query($con,"select count(distinct emailaddress) total_nee, product $customertable  importdate >='$start_date' , importdate <'$end_date' , product != '';"); $rs_nee = mysqli_fetch_array($result_nee);  $unique_customers_nee[$i] = $rs_nee['total_nee']; unset($rs_nee);  }

calling these functions 10 times , storing values in arrays


Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in...
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = ...
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more