QT wrote:
I have a database with thousands records. And every minutes I am selecting
50 rows from that database and send some data to another web url according
sellected 50 rows.
Whenever, my script finish job in one minute, I have no problem. Because
after each transaction, I am uptading
[snip]
Is there any way, to put flag or something like that, when sellecting
rows
with php and mysql?
[/snip]
You would essentially have to update each row as you retrieved it from
the database, which is highly inefficient...get one row, update the same
row, get the next row, update it...and so
I can think of a few things off the top of my head. Not that any are
perfect solutions.
The first and most obvious would be to select your 50 record set into
memory, update the records as processing, then deliver the data, then
update the records as used.
Or, have another table with one
3 matches
Mail list logo