I was wondering which is faster and more efficient (in terms of
re-indexing).
I have to make quite a few changes to TEXT fields in our database.
The TEXT fields are all on one table and the table (field) is
Full-Text indexed.
My choices are as follows:
1:
i. Get data from record.
ii. Store data in a variable.
iii. Append text to data.
iv. Delete record.
v. Create new record.
2:
i. Get pointer to field.
ii. Append text to field using UPDATETEXT
Because we use our database for a lot of real-time searching, it is
important that the index do incremental populations often. I
currently have it set to run an incremental population every hour
during office hours. Given my two scenario's, is there a difference
to which solution is better/worse in terms of this incremental
population?
Thanks for the help.
Stephan
re-indexing).
I have to make quite a few changes to TEXT fields in our database.
The TEXT fields are all on one table and the table (field) is
Full-Text indexed.
My choices are as follows:
1:
i. Get data from record.
ii. Store data in a variable.
iii. Append text to data.
iv. Delete record.
v. Create new record.
2:
i. Get pointer to field.
ii. Append text to field using UPDATETEXT
Because we use our database for a lot of real-time searching, it is
important that the index do incremental populations often. I
currently have it set to run an incremental population every hour
during office hours. Given my two scenario's, is there a difference
to which solution is better/worse in terms of this incremental
population?
Thanks for the help.
Stephan