On 25 Oct 2011 at 02:36, DealTek wrote:
> On Oct 24, 2011, at 6:23 PM, Bastien wrote:
>
>> On 2011-10-24, at 9:07 PM, DealTek 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 from a new range for a
>>
On Mon, Oct 24, 2011 at 21:07, DealTek 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 you're on Linux with
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 m
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 en
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 criter
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 wrote:
>
> Jason Pruim
> li...@pruimphotography.com
>
>
>
> On Oct 25, 2011, at 10:51 AM, Jim
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 t
On 2011-10-25, at 6:56 PM, Jason Pruim 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 need a count -
"David Robley" 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
preparation of the qu
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
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 9:58 PM, Jim Giner wrote:
> "David Robley" 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 perform
- Original Message -
From: "Jason Pruim"
To: "Jim Giner"
Cc:
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...
Jason Pruim
li...@pruimphotography.com
On Oct 25, 2011, at 10:10 PM, Jim Giner wrote:
>
> - Original Message - From: "Jason Pruim"
> To: "Jim Giner"
> Cc:
> Sent: Tuesday, October 25, 2011 10:06 PM
> Subject: Re: [PHP] Exporting large data from mysql to html using php
>
>
> It tu
On Tue, Oct 25, 2011 at 7:06 PM, Jason Pruim wrote:
>
> 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 kill
14 matches
Mail list logo
