[Resolved] query execution speed

[bike5]

I was wondering "what if". Say I have 1000 rows in my database and I need to edit one column in each by appending somthing to it. Which means I need to open each row, get a value in the row and append something to the value and then update that row.

How long would something like this take?

I know there a lot of factors that will effect the speed too but on average. In the future I might have this problem and need to know if I could run a loop 1000 times to do this in one script execution or if I would need to break it up in sections and do section by section at a time.

Thanks.

[drag0n]

if all there are is 1000 rows, it should take less then 15 seconds on almost any host, because I just had to update a 40K plus member database and it took less then 1.5 minutes on a 2.0GHZ Server. SHould be no problem, just beware of script timeouts which is setable in php.ini

[bike5]

Ok, thats good. Thanks.