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 uptadi
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 re
[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 on
Dear Sirs,
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 one of
4 matches
Mail list logo