PHP Thread script Aborted

Question

0.00/5 (No votes)

See more:

I got a php script running every 1 hour on my server (a thread). What this thread is doing is, the user can upload excel files with data, the thread compares the data in the excel file with that in the database and does something (not relevant some inserts in the database if the found rows dont exist). To read the excel file i call the :

PHP

$data = new Spreadsheet_Excel_Reader();
$data->read($file);

the user can upload more xls files, on the server called: File_1.xls, File_2.xls ,File_3.xls i read the first file get all the data do all the compares do all the inserts this can take a while sometimes its over 6000 rows in excel. I noticed that if the thread runs to long, for example he can insert file 1 and file 2 and file to is a big one like 6000+ rows i get an Abort in my error log. I think it is the excel readers fault. Any ideas?

Posted 14-Nov-12 21:02pm

T0mii

Add a Solution

2 solutions

Solution 2

As my opinion, Reading and parsing excel must load whole excel into memory and take much memory to parse excel, so please take care of the memory usage, it might be a killer of your application, you know as default setting in php.ini, there are just few memory can be used, try to add this code at top of the code snippet and see how does it go:

PHP

ini_set('memory_limit', '10240M');#Memory usage, assume you have enough memory to use.

Posted 10-Dec-12 16:58pm

zhang_2006

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

T0mii · Accepted Answer · 2012-11-19T21:14:00

Solution 1

it seems i used unset() on a private array variable, and that caused the abort in my thread. Interesting that no error messages were send, except that Aborted..

Posted 19-Nov-12 21:14pm

T0mii