Speed up excel export

[binoy <binoymvee@xxxxxxxxxxx>]

Hi friends,

Iam trying to export the datas from mysql to excel file with different color for different columns. All are working if the datas are low (about 2000), but i need to export about 8000 records from the mysql. when i try to take this mcuh record i need to wait abt 5 minutes. How can i speed up this process,
Iam pasting my code here. Please give an advice.



<?php
include ('config.php');
$select = "SELECT Tariff, Service, DeliveryDate, DeliveryTime, POD FROM pod order by Date asc";    
$export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) );
$fields = mysql_num_fields ( $export );

$row =0;

require_once "class.writeexcel_workbook.inc.php";
require_once "class.writeexcel_worksheet.inc.php";
$fname = tempnam("/tmp", "panes.xls");
$workbook = &new writeexcel_workbook($fname);
$worksheet1 =& $workbook->addworksheet('Panes 1');

    for ( $i = 1; $i < $fields; $i++ ){    
        $headerfieldname = mysql_field_name( $export , $i );
          $worksheet1->write(0, $i, $headerfieldname, '');
    }
    
    $cnt =1;
        
    $format1 =& $workbook->addformat(array('fg_color' =>'rose'));
    $format2 =& $workbook->addformat(array('fg_color' =>'yellow'));
    $format3 =& $workbook->addformat(array('fg_color' =>'purple'));
     $format4 =& $workbook->addformat(array('fg_color' =>'white'));            

    while( $row = mysql_fetch_row( $export ) )  {   

        $selectcolor = "SELECT colorname, col FROM colorscheme where row='".$cnt."' order by col";
        
        $exportcolor = mysql_query ( $selectcolor );
        $newcolors = mysql_fetch_object($exportcolor);
        $column  = $newcolors->col;
        
        for($q=1; $q <=14; $q++)  {            
        
     
            switch($newcolors->colorname) {
                case 'rose' :
                    $format = $format1;
                    break;                    
                case 'yellow' :
                    $format = $format2;
                    break;
                case 'purple' :
                    $format = $format3;
                    break;                          
                default:
                    $format = $format4;
                    break;        
            }
            
            $newcolors = mysql_fetch_object($exportcolor);
            $column  = $newcolors->col;
            
          
            $worksheet1->write($cnt, $q, $row[$q], $format );    
                
        }                
        $cnt++;    
     
            
    }
    
    $workbook->close();
    header("Content-Type: application/x-msexcel; name=\"".'Log-'.date('dmy', time()).".xls\"");
    header("Content-Disposition: inline; filename=\"".'Log-'.date('dmy', time()).".xls\"");
    $fh=fopen($fname, "rb");
    fpassthru($fh);
    unlink($fname);    

With  Regards
  Binoy.M.V
  


      Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/

[Non-text portions of this message have been removed]