General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating each record slow when using local view.
We have a table with 88,000 records. The size and description fields do not allow for a simple index expression that results in desired order so we have a maintenance function that does the sorting. Following this function we have always replaced a field, orderkey, with Recno(). Replacing each orderkey took aproximately one minute as a base table but as a local view takes 15 munutes or longer - which is unnacceptable. There is a primary key and index tag for it on the base table. We also experimented with table buffering, using one TableUpdate command upon completion of the replaces. The replaces happened very quickly but then the tableupdate command takes forever so either way this is very slow compared to our prior experience of this functionality on the base table.
For now we can use the base table but we need a remote view in the near future. Using the base table won't be an option then.
I would appeciate any suggestions regarding this problem.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only