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

[Adam]

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
listed.

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.

TIA,
Adam

[Philliph Mau]

Adam schrieb:

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
listed.

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.

TIA,
Adam

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

-phil