Click here to Skip to main content
15,888,590 members
Home / Discussions / C#
   

C#

 
GeneralSending the Excel Object Model for download Pin
dgap15-Jun-05 12:13
dgap15-Jun-05 12:13 
GeneralRTF to XML Pin
Member 202751015-Jun-05 11:55
Member 202751015-Jun-05 11:55 
GeneralRe: RTF to XML Pin
Christian Graus15-Jun-05 13:46
protectorChristian Graus15-Jun-05 13:46 
QuestionRe: RTF to XML Pin
Sandeepat.net14-Sep-10 23:57
Sandeepat.net14-Sep-10 23:57 
Generaldraw 2 transparent png one over the other Pin
Sasuko15-Jun-05 11:30
Sasuko15-Jun-05 11:30 
GeneralRe: draw 2 transparent png one over the other Pin
Christian Graus15-Jun-05 13:47
protectorChristian Graus15-Jun-05 13:47 
GeneralHttpWebRequest Troubles Pin
dhonda15-Jun-05 9:25
dhonda15-Jun-05 9:25 
QuestionBatch SqlCommand execution? Pin
Judah Gabriel Himango15-Jun-05 9:09
sponsorJudah Gabriel Himango15-Jun-05 9:09 
Hi guys,

I've got a C# smart client application that allows the user to change, create, or delete data that's stored in an MSDE SQL database. I've rolled my own messaging queue so that the when a client updates lots of data at a time (e.g. deletes 500 rows of data, create 2 rows, update 100 rows), I send a batch message to my server application containing 602 sub-messages describing what happened (in other words, one big message containing all the actual messages describing what happened). This way I only have to go over the network from client to server only 1 time.

All that works great.

My problem is that now that the "delete 500, create 2, update 100" batch message is on the server, I have to call a stored procedure in the database for each message: call RemoveRow stored proc 500 times, call CreateRow stored proc 2 times, call UpdateRow stored proc 100 times.

Using a profiler to look at my code, it is apparent that this execution of several hundred stored proc calls is a bottleneck. Is there any way to allow the MSDE database to execute a batch of commands all at once? Or better yet, is there a better way of doing this?


Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Conversation With a Muslim
Judah Himango


GeneralSockets and ArrayLists Pin
obelisk2915-Jun-05 8:33
obelisk2915-Jun-05 8:33 
GeneralRe: Sockets and ArrayLists Pin
eggie515-Jun-05 19:21
eggie515-Jun-05 19:21 
GeneralImaging Application - not enough RAM Pin
Libor Tinka15-Jun-05 8:03
Libor Tinka15-Jun-05 8:03 
GeneralRe: Imaging Application - not enough RAM Pin
DavidNohejl15-Jun-05 8:19
DavidNohejl15-Jun-05 8:19 
GeneralRe: Imaging Application - not enough RAM Pin
Judah Gabriel Himango15-Jun-05 8:30
sponsorJudah Gabriel Himango15-Jun-05 8:30 
GeneralRe: Imaging Application - not enough RAM Pin
Dave Kreskowiak15-Jun-05 8:51
mveDave Kreskowiak15-Jun-05 8:51 
GeneralRe: Imaging Application - not enough RAM Pin
DavidNohejl15-Jun-05 12:44
DavidNohejl15-Jun-05 12:44 
GeneralRe: Imaging Application - not enough RAM Pin
JDUK15-Jun-05 12:12
JDUK15-Jun-05 12:12 
GeneralRe: Imaging Application - not enough RAM Pin
Dave Kreskowiak15-Jun-05 18:52
mveDave Kreskowiak15-Jun-05 18:52 
GeneralRe: Imaging Application - not enough RAM Pin
Christian Graus15-Jun-05 13:48
protectorChristian Graus15-Jun-05 13:48 
GeneralRe: Imaging Application - not enough RAM Pin
Libor Tinka16-Jun-05 1:02
Libor Tinka16-Jun-05 1:02 
GeneralDetecting New Mail -- Exchange Server 2000 Pin
JMKerp295815-Jun-05 7:47
JMKerp295815-Jun-05 7:47 
GeneralNumber of pages in PrintPreviewControl Pin
Luis Alonso Ramos15-Jun-05 7:47
Luis Alonso Ramos15-Jun-05 7:47 
GeneralRe: Number of pages in PrintPreviewControl -- solved Pin
Luis Alonso Ramos15-Jun-05 8:50
Luis Alonso Ramos15-Jun-05 8:50 
GeneralOffice Interop - Populating Checkboxes Pin
tsmyrnio15-Jun-05 7:43
tsmyrnio15-Jun-05 7:43 
QuestionGDI+ drawing strings causes messed gaps between letters - how to fix? Pin
iliyang15-Jun-05 7:16
iliyang15-Jun-05 7:16 
AnswerRe: GDI+ drawing strings causes messed gaps between letters - how to fix? Pin
MoustafaS15-Jun-05 8:25
MoustafaS15-Jun-05 8:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.