PHP and MySQL - Script not return all possible results matching criteria

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Hello all,

I have written a script that utilizes mysql_unbuffered_query to
quickly perform a series of if statements on the returned row as my
result sets are roughly 50,000,000+ in size.

With the script I am interating through each field of the returned row
and performing a check to see if the field contains what I am
searching for.  If it does, it writes the row id to a file and
continues with the next row.

Now my problem is, when the script is finished it's run I have a file
full of row ids, but not all the rows matching the criteria are

If I then delete the rows indicated by the file from the database and
run the PHP script again I am met with rows that should have been
caught on the first run.

I have all script runtime limits turned off.  I am wondering if this
might be a problem with MySQL?

Any and all help is appreciated.


Re: PHP and MySQL - Script not return all possible results matchingcriteria

Adam schrieb:

Quoted text here. Click to load it

I think, mySQL has a process runtime limit, too. Did you turn mySQL AND
PHP limits off?


Site Timeline