php-general Digest 25 Oct 2011 12:25:34 - Issue 7536
Topics (messages 315402 through 315418):
Exporting large data from mysql to html using php
315402 by: Jason Pruim
315404 by: Shiplu Mokaddim
315405 by: Bastien
315409 by: Jim Giner
315410 by:
php-general Digest 26 Oct 2011 01:43:16 - Issue 7537
Topics (messages 315419 through 315426):
Re: Geo IP Location help needed...
315419 by: Daniel Brown
Re: Exporting large data from mysql to html using php
315420 by: Jim Giner
315422 by: Jason Pruim
315423
On 25 Oct 2011 at 02:36, DealTek deal...@gmail.com wrote:
On Oct 24, 2011, at 6:23 PM, Bastien wrote:
On 2011-10-24, at 9:07 PM, DealTek deal...@gmail.com wrote:
If the IP is showing, could there be some left over debug in some function?
If the IP is not in your list it could be anything
On Mon, Oct 24, 2011 at 21:07, DealTek deal...@gmail.com wrote:
Q: Is there some code that can ALWAYS tell the country name of the IP?
More often than not, you will get accurate, real-time (as in, not
static and potentially stale from a database) results using a direct
WHOIS query. If
I disagree. It's not about tuning the queries, it is more about the appl.
design that currently thinks it SHOULD do such huge queries.
My approach would be to prompt the user for filtering criteria that
automatically would reduce the result set size. Although at this time I
believe the OP
On Oct 23, 2011, at 9:38 PM, tamouse mailing lists wrote:
http://reflectionbeads.com/i/design-your-own
That's a very interesting site. Surprising that it doesn't use a lick
of PHP to do what it's doing, given what you wrote below.
How do you know that? Just to be argumentative, the entire
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 10:51 AM, Jim Giner wrote:
I disagree. It's not about tuning the queries, it is more about the appl.
design that currently thinks it SHOULD do such huge queries.
My approach would be to prompt the user for filtering criteria
Again why even do a detail query? Nobody is going to examine pages and pages
and etc.
Do a summary qry if u just need a count - no pagination there
jg
On Oct 25, 2011, at 6:26 PM, Jason Pruim li...@pruimphotography.com wrote:
Jason Pruim
li...@pruimphotography.com
On Oct 25,
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 6:35 PM, Jim Giner wrote:
Again why even do a detail query? Nobody is going to examine pages and
pages and etc.
Do a summary qry if u just need a count - no pagination there
jg
The bosses wanted them to be able to page
On 2011-10-25, at 6:56 PM, Jason Pruim li...@pruimphotography.com wrote:
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 6:35 PM, Jim Giner wrote:
Again why even do a detail query? Nobody is going to examine pages and
pages and etc.
Do a summary qry if u just
David Robley robl...@aapt.net.au wrote in message
news:49.50.34068.1b567...@pb1.pair.com...
Consider running EXPLAIN on all your queries to see if there is something
Mysql thinks could be done to improve performance.
Why do so many responders seem to think the problem here is in the
Jason Pruim wrote:
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 10:51 AM, Jim Giner wrote:
I disagree. It's not about tuning the queries, it is more about the
appl. design that currently thinks it SHOULD do such huge queries.
My approach would be to prompt the
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 9:58 PM, Jim Giner wrote:
David Robley robl...@aapt.net.au wrote in message
news:49.50.34068.1b567...@pb1.pair.com...
Consider running EXPLAIN on all your queries to see if there is something
Mysql thinks could be done to
- Original Message -
From: Jason Pruim li...@pruimphotography.com
To: Jim Giner jim.gi...@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
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 10:10 PM, Jim Giner wrote:
- Original Message - From: Jason Pruim li...@pruimphotography.com
To: Jim Giner jim.gi...@albanyhandball.com
Cc: php-general@lists.php.net
Sent: Tuesday, October 25, 2011 10:06 PM
Subject: Re:
On Tue, Oct 25, 2011 at 7:06 PM, Jason Pruim li...@pruimphotography.comwrote:
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
16 matches
Mail list logo