I've developed a simple stock tacking application in VS 2005 using SQL Server CE for a MC3000 device running CE 5.0. See here http://www.bar-codenow.com/symcbamoco.html

The application works fine but after scanning around 20-30 products the app slows down and eventually you start to see database errors. (With each scan it looks up a product record and records the count to a transaction table.)

The device I'm using has 32mb of ram and the database sits on a 1gb storage card. I've tried the 'SSCE:Temp File Directory' setting but it doesn't make a difference. The database itself is only a couple of mb.

I have noticed if I exit the application and re-enter the problem goes away for another 20 or so scans.

Does anybody have any idea's how I can free up some more room or what the problem may be?

Thanks