[PHP] Re: [PHP-DEV] 5.4.0 beta2

2011-10-24 Thread Daniel Convissor
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.

[PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jason Pruim
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

[PHP] Geo IP Location help needed...

2011-10-24 Thread DealTek
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:

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Shiplu Mokaddim
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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 8:50 PM, Jason Pruim li...@pruimphotography.com 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,

Re: [PHP] Geo IP Location help needed...

2011-10-24 Thread Bastien
On 2011-10-24, at 9:07 PM, DealTek deal...@gmail.com 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

Re: [PHP] Geo IP Location help needed...

2011-10-24 Thread DealTek
On Oct 24, 2011, at 6:23 PM, Bastien wrote: On 2011-10-24, at 9:07 PM, DealTek deal...@gmail.com 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

Re: [PHP] Geo IP Location help needed...

2011-10-24 Thread Tommy Pham
On Mon, Oct 24, 2011 at 7:03 PM, Tommy Pham tommy...@gmail.com wrote: On Mon, Oct 24, 2011 at 6:36 PM, DealTek deal...@gmail.com 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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jim Giner
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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 10:44 PM, Jim Giner jim.gi...@albanyhandball.com 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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jason Pruim
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 --

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jason Pruim
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 li...@pruimphotography.com wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jim Giner
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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 11:26 PM, Jim Giner jim.gi...@albanyhandball.com 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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 11:14 PM, Jason Pruim li...@pruimphotography.com 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 li...@pruimphotography.com wrote: Now that I've managed to list 3 separate

[PHP] Re: Exporting large data from mysql to html using php

2011-10-24 Thread David Robley
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

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread tamouse mailing lists
On Mon, Oct 24, 2011 at 7:50 PM, Jason Pruim li...@pruimphotography.com 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