when the database start under sqlanywhere 8, i get the message database file "c:\test\test.db" consists of 17497 disk fragments, and some queries is so slow it's related to this error????
You should defragment the drive when the Database is offline.
Or use CONTIG from Sysinternals to defragment only the database file.
The database file will get fragmented when the database needs more space and the file is grown. You can reduce the fragmentation if you add larger chunks to the database at a time with the ALTER DBSPACE command.
answered 26 Sep '12, 02:53