I want to append a word to a TEXT field.

so I use:

UPDATE my_table SET my_text=concat(my_text,"a word") WHERE ...

this statement will be repeated for millions of times, and my_text has
contained maybe 50K characters.

It works too slowly. How can I impove it?

thanks.

<lionchao (AT) gmail (DOT) com> wrote

Is the text a constant? Is it easy to specify what rows as a set?
For example if you update row by row it will be very slow. If you can
update many rows at the same time it will be much faster. eg
update my_table set my_text=my_text||"a word";
Jim

Thank you for reply. The additional word is different for each row.

Jim Kennedy wrote:

lionchao (AT) gmail (DOT) com wrote:
There is a chance that some database genious will provide a short
circuit to do this faster, but my impression is that you're close to the
limit of what performance, you can expect.

If you need to be able to do something like this, another way of getting
it done, is to represent the text in some other way in the database,
making it faster (but possibly more complicated) to add words. This all
depends on the actual use.

Regards,

Michael.

P.s. please don't top post.
--
Which is more dangerous? TV guided missiles or TV guided families?
I am less likely to answer usenet postings by anonymous authors.
Visit my home page at http://michael.zedeler.dk/

I think the key point of this statement is that it should read all the
words out and then write them in.

Is there an SQL statement like "APPEND"?