View, cursor or somethig else?
Save to folder
I have 5 machine network with an NT4 file server.
To reduce the network traffic, I would like to have an always up-to-date local list from the product table. This list would contain only the product names. (Number of these can be greater than 10000)
The problem is (for me), keeping the local list always updated.
I consulted to dev.guide and found that sql view could be a possible solution, but the update algorythm is not clear for me.
I a not quite sure, how can I start and stop the updating. Is it continouos or not. If it is, than should I stop it when I show a list based on this.
I saw, that a cursor also can be updated, I thought it from the very similar properties to the view properties. Would it be a better solution?
Or is there a nother possible way?
Thanks in advance: