469,270 Members | 1,737 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

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

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
1 1528
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.

Similar topics

3 posts views Thread by JT | last post: by
15 posts views Thread by Stat | last post: by
reply views Thread by Mike Chirico | last post: by
11 posts views Thread by DJJ | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.