I’m trying to get my head around to make better way to increase the performance of my application System based on single SQL Server with 50 clients tablets pc(its connected to local wireless). my application is winform and its used VB.net 4.5 framework. Client’s tablets are rapidly accessing to centralise SQL server for transactions. currently System is working without any interruption but sometimes users are complaining about its slowness
I think problem is its concurrently accessing the same tables. To reduce load i tried Two ways but both are failed
1) I created CSV file based on SQL table then tried to accesses that- Fail because it’s not updated.
2) Tried to replicate the tables in to locally installed SQL Server(Tablet)-Fail Tablet is not strong enough to run SQL Express