This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have a Sqlserver database that has a half-hourly batch feed from a mainframe. This mainframe is inserting data into a few database fields that require concurrent access to them by a web-based client. Currently, when the feed is happening, performance is severely degraded.
My question: does this feed from the mainframe (there is no push of data from the db --> mainframe) lock access to the table, so do users need to be patient and wait for the batch to end? I'm re-writing the whole application (db schema included), so if there's things I can do to stop this, please advise!