Using SQLLite transactions I/O Error
- by james.ingham
I currently have a client / server setup where the client sends data to the server and then the server saves the data to a SQLite database file. To do this I am using transactions which works fine in windows 7 when I run around 30 clients (each client sending data back between 5 - 30 seconds).
When using the same software in Windows XP, I can get/set data multiple times with no problems until I run around 20 clients I start to get Windows Delayed wrote failed errors:
This fires an exception on the server:
I'm assuming this is either something to do with XP or a hardware issue on the machine i'm running XP.
Does anyone have any advice to avoid this? Or if I should just catch the exception and retry saving the data?
Thanks