I came across this one which i taught was very interesting….

 

basically an app logs on and uses a sql express database for whatever reason… well lets say the user leaves their desk and returns 15 minutes later… which is a common enough experience. They log back on to the app and they notice a timeout on the app or very slow to initially respond.

 

well this could be cause be sql express after about 10 mins it will close database connections and flush its cache…. if you want dont want this problem your app has to be programmed to work in the background to query a db every couple of minutes, doesnt have to do anything specific but just run a simply read query against the database… and then should fix it!

interesting little problems…

Advertisements