We are considering the option of replacing SQL CE with VistaDB for the local database of our application. But we noticed that with VistaDB the file size keeps on growing and it gets significantly larger than SQL CE file size. Example : VistaDB goes beyond 15MB while SQL CE sits around 1-2 MB.
If Pack Database is performed, then it reduces the size back to 1-2 MB range (Still larger than SQL CE). But that's not an option as multiple instances of the application can access the VistaDB file, hence it's not always possible to get exclusive access to the file.
Is there any other option or any optimisation strategies to reduce the file size?
Thanks for reaching out to us!