On Mon, Oct 24, 2011 at 7:50 PM, Jason Pruim wrote:
> I have about 89 million records in mysql... the initial load of the page
> takes 2 to 3 minutes, I am using pagination, so I have LIMIT's on the SQL
> query's... But they just aren't going fast enough...
>
> What I would like to do, is pull t
Jason Pruim wrote:
> Now that I've managed to list 3 separate programming languages and
> somewhat tie it back into php here's the question...
>
> I have about 89 million records in mysql... the initial load of the page
> takes 2 to 3 minutes, I am using pagination, so I have LIMIT's on the SQL
>
On 2011-10-24, at 11:14 PM, Jason Pruim wrote:
>
> Jason Pruim
> li...@pruimphotography.com
>
>
>
> On Oct 24, 2011, at 9:20 PM, Bastien wrote:
>
>>
>>
>> On 2011-10-24, at 8:50 PM, Jason Pruim wrote:
>>
>>> Now that I've managed to list 3 separate programming languages and somewhat
>>
On 2011-10-24, at 11:26 PM, "Jim Giner" wrote:
> Yes - but - we're talking about a user-app that the OP is trying to provide
> 89M records to. Sure - "some" users might have need of looking at even as
> much as a million records IF they were researching something that needed it.
> But - for
Yes - but - we're talking about a user-app that the OP is trying to provide
89M records to. Sure - "some" users might have need of looking at even as
much as a million records IF they were researching something that needed it.
But - for the 'general' user of an app - I cannot see a need to be p
Jason Pruim
li...@pruimphotography.com
On Oct 24, 2011, at 9:20 PM, Bastien wrote:
>
>
> On 2011-10-24, at 8:50 PM, Jason Pruim wrote:
>
>> Now that I've managed to list 3 separate programming languages and somewhat
>> tie it back into php here's the question...
>>
>> I have about 89 mil
On Oct 24, 2011, at 10:44 PM, Jim Giner wrote:
> Why would any user need to have access to 89M records?
They don't need access to it to edit it... Just to be able to view it... Also,
it will be expanding in the future to include alot more data.
Jason Pruim
li...@pruimphotography.com
--
PH
On 2011-10-24, at 10:44 PM, "Jim Giner" wrote:
> Why would any user need to have access to 89M records?
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
History or audit trail data? I can think of lots. I know of an app wit
Why would any user need to have access to 89M records?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Mon, Oct 24, 2011 at 7:03 PM, Tommy Pham wrote:
> On Mon, Oct 24, 2011 at 6:36 PM, DealTek wrote:
>
>
>>
>> but maybe the db is old from - Geo IP Location? hmmm . how do I check?
>>
>> --
>> Thanks,
>> Dave - DealTek
>> deal...@gmail.com
>> [db-11]
>>
>>
>>
> Dave,
>
> I don't Linux too well
On Oct 24, 2011, at 6:23 PM, Bastien wrote:
>
> On 2011-10-24, at 9:07 PM, DealTek wrote:
>
>
> Dave,
>
> 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
> region to IP spoofing or so
On 2011-10-24, at 9:07 PM, DealTek wrote:
> newbie question!
>
> Hi all,
>
> So, I had - Geo IP Location - installed for me on my VPS server by a network
> tech
>
> http://us3.php.net/manual/en/book.geoip.php
>
>
> then I used:
>
> geoip_country_name_by_name(xxx) to display the country
On 2011-10-24, at 8:50 PM, Jason Pruim wrote:
> Now that I've managed to list 3 separate programming languages and somewhat
> tie it back into php here's the question...
>
> I have about 89 million records in mysql... the initial load of the page
> takes 2 to 3 minutes, I am using pagination
2-3 minutes is long enough. I think your SELECT query and MySQL schema has
something that can be improved.
Sent from a handheld device.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
newbie question!
Hi all,
So, I had - Geo IP Location - installed for me on my VPS server by a network
tech
http://us3.php.net/manual/en/book.geoip.php
then I used:
geoip_country_name_by_name(xxx) to display the country by name
basically works ok - however a few people say that my page:
Now that I've managed to list 3 separate programming languages and somewhat tie
it back into php here's the question...
I have about 89 million records in mysql... the initial load of the page takes
2 to 3 minutes, I am using pagination, so I have LIMIT's on the SQL query's...
But they just are
Hi Stas:
> The next release is planned to be RC1 and is scheduled for November 10.
You want the DateTime DST fixing RFC
(https://wiki.php.net/rfc/datetime_and_daylight_saving_time) implemented
before RC1, right? If so, keep in mind that voting on it will start
tomorrow and finish on November 1.
17 matches
Mail list logo
