Jason Pruim
lists@xxxxxxxxxxxxxxxxxxxx
On Oct 25, 2011, at 10:10 PM, Jim Giner wrote:
>
> ----- 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.
It's walking the fine line between what I want, and what the people who are paying for it want... What I always try and do is give them what they ask for, but also give them what they want... because what they ask for != what they want MOST of the time... So most likely I will end up pulling the pagination and really limiting the searching...
But until I convince the right people... I go on as planned.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
