By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.