Vfrdtyky

I am retrieving 5000 plus data in my MYSQL database. I takes 5-10 minutes to retrieve the data (it is only just local slower when over the network) is there a way to improve the speed without using a plugin?

$ContactID = $_GET["Contact"];



    $sql = "SELECT * FROM tblContacts WHERE Coordinator = '$ContactID'";

    $result = mysqli_query($conn, $sql);

    $count = mysqli_num_rows($result);



    if($count > 0){

        while ($row = mysqli_fetch_array($result)) {

            $supdate = date("Y-m-d h:i", strtotime($row['ServerUpdate']));

            $mupdate = date("Y-m-d h:i", strtotime($row['MobileUpdate']));

            $ar = array(

                'ContactID' => $row['ContactID'],

                'FileAs' => $row['FileAs'],

                'FirstName' => $row['FirstName'],

                'MiddleName' => $row['MiddleName'],

                'LastName' => $row['LastName'],

                'Position' => $row['Position'],

                'Company' => $row['Company'],

                'CompanyID' => $row['CompanyID'],

                'ContactType' => $row['ContactType'],

                'RetailerType' => $row['RetailerType'],

                'PresStreet' => $row['PresStreet'],

                'PresBarangay' => $row['PresBarangay'],

                'PresDistrict' => $row['PresDistrict'],

                'PresTown' => $row['PresTown'],

                'PresProvince' => $row['PresProvince'],

                'PresCountry' => $row['PresCountry'],

                'Landmark' => $row['Landmark'],

                'Telephone1' => $row['Telephone1'],

                'Telephone2' => $row['Telephone2'],

                'Mobile' => $row['Mobile'],

                'Email' => $row['Email'],

                'Employee' => $row['Employee'],

                'Customer' => $row['Customer'],

                'Coordinator' => $row['Coordinator'],

                'ServerUpdate' => $supdate,

                'MobileUpdate' => $mupdate

            );

        }



        print json_encode($ar);

    }      

$ContactID = $_GET["Contact"];

$ar = array();

$sql = "SELECT ContactID,FileAs, FirstName ,MiddleName ,LastName ,Position ,Company ,CompanyID  ,ContactType ,RetailerType ,PresStreet 

             ,PresBarangay ,PresDistrict  ,PresTown , PresProvince  ,PresCountry ,Landmark   ,Telephone1 , Telephone2  ,Mobile 

              ,Email  ,Employee  ,Customer  ,Coordinator  FROM tblContacts WHERE Coordinator = '$ContactID'";

$result = mysqli_query($conn, $sql);

$count = mysqli_num_rows($result);



if($count > 0){

    $rowCount = 0;

    while ($row = mysqli_fetch_array($result)) {

        $supdate = date("Y-m-d h:i", strtotime($row['ServerUpdate']));

        $mupdate = date("Y-m-d h:i", strtotime($row['MobileUpdate']));

        $ar[$rowCount] = $row;

        $ar[$rowCount]['ServerUpdate'] = $supdate;

        $ar[$rowCount]['ServerUpdate']  = $mupdate;

         $rowCount++;

    }



    print json_encode($ar);

}      

You must declare the variable of array first in the top.

You can directly call from mysql what data needed. Hope can help.

It could be like this way.

$contactID = $_GET["Contact"];

$sql = "SELECT * FROM tblContacts WHERE Coordinator = '$contactID'";

$result = mysqli_query($conn, $sql);

if(mysqli_num_rows($result) > 0){

    $data = array();

    while($row = mysqli_fetch_array($result)){



        $row['supdate'] = date("Y-m-d h:i", strtotime($row['ServerUpdate']));

        $row['supdate'] = date("Y-m-d h:i", strtotime($row['MobileUpdate']));



        $data = $row;

    }

    print json_encode($data);

}    

updated for multiple records