General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Virtual environment:
VMWare
A few more thoughts:
- when a user "copies" a quote, the current procedure puts the records to be added into a view and then posts the records as a batch
- in the past under older code, I instead added these records via doing a SCATTER from the source record and then an APPEND BLANK into the target table followed by a GATHER; I can't say this worked foolproof either
- in my mind, there should be no difference between a view posting new records and doing so via APPEND BLANK or INSERT INTO - lock the header, add in the rows, write in the data, unlock the header etc
---> is there a difference?
- there is no buffering on the target table...would it work better if there was? Again, I don't see how this would make a difference but am just looking for ideas?
Thanks all.
Albert
Previous
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