I have an app with a search action that runs against a table with
about 200K+ rows. The table contains an integer field that contains a
counter for each time a record is "matched" in a search, basically for
relevancy tracking. Sometimes the search yield 50 matches, sometimes
they yield 50 thousand. Currently, we're running the search and
following it up with an update action using the same parameters to
increment the counter column (SET ColumnName = ColumnName+1 WHERE...).
This worked fine when the table only contain 50K records, but now it's
starting to take it's toll on the system performance. If it takes 5
seconds to perform the search, it takes another 5 seconds to perform
the update.
Anyone know if there's a SQL command (MSSQL 7) out there that can
update a record at the same time it is involved in a select
statement???? If not, I'm certainly open to other suggestions.
Nathan Hitchcock
HLI Systems
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
