Re: Exporting large data from mysql to html using php

Jason Pruim lists@pruimphotography.com On Oct 25, 2011, at 10:10 PM, Jim Giner wrote: > > ----- Original Message ----- From: "Jason Pruim" <lists@pruimphotography.com> > To: "Jim Giner" <jim.giner@albanyhandball.com> > Cc: <php-general@lists.php.net> > Sent: Tuesday, October 25, 2011 10:06 PM > Subject: Re: [PHP] 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.