Hi SQLiteUsers Developing MFC Application (Small Business Accounting Application) (developed using Visual Studio) - App will run on Windows 98/2000 - App uses SQLite database files for storage of data - It will have one database for each company accounts/info. So if accounts of 10 companies, then info will be in 10 different SQLite DB files. - All Database files on same disk. - User of App may create more company file for accounts of another company. - User of App may open any existing company file and enter/modify transactions through different GUI screens. - User closes file and may open another company file and enter/modify transactions through different GUI screens.
After using such application, all used SQLite DB files gets fragmented. How to avoid such fragmentation ? Is there any feature, to pre-allocate disk-space to SQLite database file so that initially some free space will be allocated to new file ? Is there any feature, so that when database file gets filled, everytime automatically increment file size by say 25% or 40% of size ? FYI: Such pre-allocation of space and automatic incrementing file size is provided for Database files in SQLServer, Oracle etc. Rohit -- View this message in context: http://www.nabble.com/Avoiding-Fragmentation-of-SQLite-database-file-----t1780629.html#a4848030 Sent from the SQLite forum at Nabble.com.
