We have a c# based application which uses a sqlce 3.5 database, as the amount of data this requires has increased we appear to be getting "out of memory" errors!
I have made some observations and would like somebody to confirm them if possible: -
- If opening the database at the beginning of the application and keeping it open during lots of reads/writes/deletes then the database size grows similar to an Access database some sort of work area that's only released upon closing the connection.
- In an attempt to prevent the above we modified the code to close the db connection every tenth operation and then re-open the connection when next needed. Now this appears to have created another problem whereby the system now crashes with "out of
memory" errors even though there is available memory on the device at this point.
So to conclude what exactly is the way forward/best practice with regards making our application as robust as possible in relation to coding?
Thanks in advance
View Complete Post