Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TintinSnowy
Starting Member
1 Post |
 Posted - 2012-06-12 : 16:36:25
|
| Experts - We are trying to create an ODS built on SQL Server 2008. There are around 8000 POS applications that would push data into this SQL Server database. Amazon cloud WS would be middle tier that would process the messages and send to the SQL Server. The POS applications sends raw SQL INSERT statements. My question is, 1) Will just executing the SQL INSERTS into the database cause some locking, blocking or any other performance issues ( as they are not compiled ) 2) Should we try to get the data in XML format ( with the help of POS application team ) and have stored procedures to process the data ? Will this be performance effective ?Any other pointers on which would be the better approach ( Direct INSERT statements or XML with stored procedure processing ).Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-12 : 20:26:02
|
| if you can organise the data into batches and load them using XML to ODS as batch loads via stored procedure then definitely thats much better large amount of single row inserts------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
XML parsing vs Direct INSERT statements.