Re: [PHP] PHP cron job optimization

2011-09-12 Thread Igor Escobar
Use PHP threads. Do the job separately.. in parts... in other words... you can't read all them at once. You can read a little more about php multithreading here: http://blog.motane.lu/2009/01/02/multithreading-in-php/ You can use a non-relational database like mongo or couchdb to manage where you

Re: [PHP] PHP cron job optimization

2011-09-12 Thread Igor Escobar
Other good point is: always set a timeout connection when you're getting the RSS data to avoid your thread get stuck unnecessary. Use cURL (is much more faster then file_get_contents). Multithreading in PHP with cURL http://devzone.zend.com/article/3341 Regards, Igor Escobar *Software Engineer *

Re: [PHP] PHP cron job optimization

2011-09-12 Thread Eric Butera
On Mon, Sep 12, 2011 at 9:37 AM, Igor Escobar wrote: > Other good point is: always set a timeout connection when you're getting the > RSS data to avoid your thread get stuck unnecessary. Use cURL (is much more > faster then file_get_contents). > > Multithreading in PHP with cURL http://devzone.zen

[PHP] Stop PHP execution on client connection closed

2011-09-12 Thread Marco Lanzotti
Hi all, I'm new in the list and I already have a question for you. I'm running an heavy query on my DB in a PHP script called by AJAX. Because client often abort AJAX connection to ask a new query, I need to stop query because DB will be too loaded. When AJAX connection is aborted, PHP script doesn

Re: [PHP] PHP cron job optimization

2011-09-12 Thread Igor Escobar
@Eric ok ;) Regards, Igor Escobar *Software Engineer * + http://blog.igorescobar.com + http://www.igorescobar.com + @igorescobar On Mon, Sep 12, 2011 at 10:52 AM, Eric Butera wrote: > On Mon, Sep 12, 2011 at 9:37 AM, Igor Escobar > wrote: > > Other goo

[PHP] Re: Stop PHP execution on client connection closed

2011-09-12 Thread Al
See http://us2.php.net/manual/en/function.connection-aborted.php On 9/12/2011 10:40 AM, Marco Lanzotti wrote: Hi all, I'm new in the list and I already have a question for you. I'm running an heavy query on my DB in a PHP script called by AJAX. Because client often abort AJAX connection to ask a