Re: Exporting large data from mysql to html using php

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




----- Original Message ----- From: "Jason Pruim" <lists@xxxxxxxxxxxxxxxxxxxx>
To: "Jim Giner" <jim.giner@xxxxxxxxxxxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Tuesday, October 25, 2011 10:06 PM
Subject: Re:  Exporting large data from mysql to html using php


It turns out the issue was actually in the pagination... I'm reworking the whole thing and stream lining it... But in the pagination that I found on the internet it used a "SELECT COUNT(*) WHERE state='{$state}'"; and the COUNT was killing the time... Once that was removed, I was displaying records faster then I could imagine... So it's off to pagination land to fix it! And possibly redo the entire thing!
************

So you're still going to generate pages and pages of an un-manageable volume of data?

Sorry, but I offer my congratulations on producing a technically marvelous solution, and my condolences for a completely worthless application.







--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux