Slow data retrieval which requires improvement..please help

Posted on 16th Feb 2014 07:03 pm by admin

I am working on a Help Desk Ticketing system and have a page called MY TICKETS which shows all tickets in grids. the problem is that the number of records are around 30 to 40 but there is a lag around more then 10 seconds while populating the grid. I think its the way I've written. So I need suggestion to improve or correct my problems if any. Please help..here is the code

MyTickets.php
Code: <?php
session_start();
if (!isset($_SESSION['uid']))
{
header('location: login.php');
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CRPL Support - My Tickets</title>
<link rel="stylesheet" href="css/eticket.css" media="screen">
</head>

<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>


<script type="text/javascript" src="js/testajax.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CRPL Support System</title>
</head>

<body>
<div class="container">
<h1><img src="images/logosupport.gif" alt="crplTicket" width="222" height="59" border="0"></h1>
<div class="nav">
<ul>
<li>
</li>
<li id="home"><a href="newticket.php"><img src="images/home.gif" border="0" alt="Main" />New Ticket </a></li>
<li id="mytickets"><a href="mytickets.php"><img src="images/my_tickets.gif" border="0" alt="Main" /> My Tickets</a></li>
</ul>
</div>
<div class="content">

<center> </center>
<div style="margin: 10px 0 60px 0;">
<table width="100%" border="0" cellspacing=0 cellpadding=0 align="center">
<tr>
<td nowrap >
<a href="javascript:filterOpen()"><img src="images/view_open_btn.gif" alt="View Open" border=0></a>
<a href="javascript:filterClosed()"><img src="images/view_closed_btn.gif" alt="View Closed" border=0></a> <a href="javascript:nofilter()"><img src="images/refresh_btn.gif" alt="Refresh" border=0></a>
</td>
</tr>
</table>

<div id="grid_data">
</div>

<div style="clear:both"></div>
</div>
<div class="pre-footer"><br />
<br />
<br />
Support Ticket S</div>
<div class="footer"><table border="0" width="100%">

<tr>
<td><a href="http://www.cr-pl.com" target="_blank">Powered by CRPL</a>
<form id="form1" name="form1" method="post" action="">
<input type="hidden" name="vtype" id="vtype" value="G"/>

<?php session_start();
$mycus_idx = $_SESSION["uid"];
?>
<input type="hidden" name="mycusid" id="mycusid" value=<?php echo $mycus_idx ?> >
</form></td>
<td align="right"> </td></tr>
</table></div>
</div>
</div>
<br/>
<script>
//call after page loaded
window.onload=defaultgrid;
</script>

</body>
</html>

As you can see at the bottom I've used a javascript which triggers at the end of the page..

defaultgrid javascript
-----------------------------

Code: function defaultgrid()
{
var dataString = "mycusid="+document.getElementById('mycusid').value+"&dtype="+document.getElementById('vtype').value+"&sid="+Math.random();
$.ajax({
type: "GET", //GET Method used instead of POST
url: "buildgrid.php", //php file that processes the data
data: dataString, //Pass the data
cache: false, //Do not cache the page
success: function(returnString)
{
document.getElementById('grid_data').innerHTML = returnString;
}
});
}

Finally the code which actually populates the grid...
---------------------
buildgrid.php
---------------------

Code: <?php
require_once('hostinfo.php');

// Connect to server and select databse.
$connection = mysql_connect($dbhost, $dbuser, $dbpass) or die("Error : Cannot connect to the database..");
mysql_select_db($dbname) or die("Error : Cannot select Database...");

//Display type
$vtype = $_GET['dtype'];
$pcusid = $_GET['mycusid'];

if($vtype == 'G')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' order by ticketdate desc";
}

if($vtype == 'O')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' AND status='O' order by ticketdate desc";
}

if($vtype == 'C')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' AND status='C' order by ticketdate desc";
}

if($vtype == 'D')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' and department='S' order by ticketdate desc";
}
//Execute Statement using mySQL database
$result = mysql_query($squery, $connection) or die(mysql_error());
$ticketRS = mysql_fetch_assoc($result);

if($ticketRS["ticketno"] == "")
{
echo "<br/><br/> No ticket found ...";
return;
}
echo "<table width='100%' border='0' cellspacing=0 cellpadding=2>";
echo "<tr>";
echo "<td>";
echo "<table border='0' cellspacing=0 cellpadding=2 class='tgrid' align='center'>";
echo "<tr>";
echo "<th width='105' height='20' nowrap>";
// echo "<a href='view.php?sort=ID&order=ASC&' title='Sort By Ticket ID ASC'>Ticket #</a></th>";
echo "Ticket #</th>";
echo "<th width='100'>";
// echo "<a href='view.php?sort=date&order=ASC&' title='Sort By Date ASC'>Creation Date</a></th>";
echo "Creation Date</th>";
echo "<th width='60' align='center'>Status</th>";
echo "<th width='240'>Subject</th>";
echo "<th width='150' align='center'>";
// echo "<a href='view.php?sort=dept&order=ASC&' title='Sort By Category ASC'>Department</a></th>";
echo "Department</th>";
echo "<th width='150'>Priority</th>";
echo "<th width='150'>City</th>";
do
{
$theticket = "'" .$ticketRS["ticketno"] . "'";

echo "<tr class='row1' id='496115'>";
echo "<td align='center' title='" .$ticketRS["ticketno"]. "' nowrap>";
// echo "<a class='Icon webTicket' href=javascript:viewticket(" .$ticketRS["ticketno"]. ",'Grid')>" .$ticketRS["ticketno"]."</a></td>";
echo "<a class='Icon webTicket' href=javascript:viewticket(" .$theticket. ",'Grid')>" .$ticketRS["ticketno"]."</a></td>";
// echo "<a class='Icon webTicket' href='javascript:zahid()'>" .$ticketRS["ticketno"]."</a></td>";
echo "<td nowrap> " .$ticketRS["ticketdate"]. "</td>";

echo "<td> " ;
if($ticketRS["status"] == "O")
{
echo "Open" ;
} else
echo "Close";
echo " </td>";
echo "<td> " .$ticketRS["subject"] . " </td>";
echo "<td align='center'> ";
if($ticketRS["department"] == 'H')
{
echo "Hardware" ;
}else
echo "Software"; echo " </td>";
echo "<td align='center'>";
if($ticketRS["priority"] == 'H') echo "High" ; if($ticketRS["priority"] == 'N') echo "Normal" ;
if($ticketRS["priority"] == 'L') echo "Low" ; echo "</td>";
echo "<td align='center'>" .$ticketRS["city"] . "</td>";
echo "</tr>";
} while ($ticketRS = mysql_fetch_assoc($result));
echo "</table> </td> </tr> <tr> <td> </table>";
?>

No comments posted yet

Your Answer:

149

Other forums

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

Handling text changed in text box control using Ajax
I need to create a web form with a text box control. When someone types text into the textbox I nee

Not "Just Another" MMORPG - text based.
Hello,

I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Passing variables with pagination - iterating through unique id per link
Hi everyone,
I have seen a few topics like this one. Still cant find the specific thing, so I am

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

Procedural to OOP
ohn Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pri

Indyaspeak

Slow data retrieval which requires improvement..please help

Your Answer:

Other forums

Follow Us