Improve processing speed of web page in PHP Mysql

Question

My website take too much to load.I want to show a table on top of page and on bottom of page.

To get the same result twice,I am using same query two times.What is the best way to fetch data only once so that we improve speed?

Here is my code AT TOP

$q_s ="SELECT id,ref,name,description FROM TABLE WHERE status=2 AND is_archive=0 
ORDER  BY id DESC limit 5";
     $res = $objApp->query($q_s); 
  while($rw = $objApp->row($res)){
  //display my data here in div1
 }

AT BOTTOM

$q_s2 ="SELECT id,ref,name,description FROM TABLE WHERE status=2 AND is_archive=0 
ORDER  BY id DESC limit 5";
     $res2 = $objApp->query($q_s2); 
  while($rw = $objApp->row($res2)){
  //display my data here in div2
 }

NOTE:DIV1 and DIV2 are two different html.Also i showed only simplest query,its too complecated in my case.

How can i improve it?Sorry i am new to PHP

Caching doesn't help in all cases. You can always re-use the same result set $res. — Raptor
– Raptor, Commented Oct 21, 2013 at 8:01
How i can cache it?and to use $res again,it give me empty... — user2897314
– user2897314, Commented Oct 21, 2013 at 8:02
at the very top define an empty array $result = array() and in your first while loop, build it up then use it everywhere you want without the need to query DB — Ahmad
– Ahmad, Commented Oct 21, 2013 at 8:04
@Ahmad:I can not get you?Can you give me an example so that i accept your answer?(if it worked) — user2897314
– user2897314, Commented Oct 21, 2013 at 8:06
@Muhammad I have posted an answer with example, hope it helps make it clear for you — Ahmad
– Ahmad, Commented Oct 21, 2013 at 8:11

Ahmad · Accepted Answer · 2013-10-21 08:11:14Z

1

Here is what I would do

$rows = array();

$q_s ="SELECT id,ref,name,description FROM TABLE WHERE status=2 AND is_archive=0 
ORDER  BY id DESC limit 5";
     $res = $objApp->query($q_s); 
  while($row = $objApp->row($res)){
   array_push($row, $rows);
 }

You can use $data in a foreach loop for an example

foreach($rows as $row) {
   echo $row['colname'];
}

Now you can use data anywhere, multiple times in the page without doing any more queries, hope this helps :)

answered Oct 21, 2013 at 8:11

Ahmad

1,88113 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Improve processing speed of web page in PHP Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related