I am working on an application which will be like users will be working offline (most likely a window app) all day saving 10-50 rows of data on to a text file and at the end of the day when they come online they will be uploading the data to main sql server database using the app. There may be hundereds of users saving information at a time within a short span of 20-30 mins.
I am totally new to developing an application which has that amount of activity. Can anyone tell me the best possible strategy so as to avoid issue on concurrent saving in case of too many users. Will Sql Server 2005 will do ok or my app is likely to face any issue. Any errors that I might run in to.
Any help is appreciated !
View Complete Post