I develop a dbms application to do some queries,and the dbms file size is more than 10MB,so make the query speed down.
Is there anyone tell me how to make the dbms file size to be small? thanks!
Run RDbDatabase::Compact. This will help if you had lot of delete operations. If it still doesnt help then try normalising tables and avoid data redundancy.
Forum posts: 285
Run RDbDatabase::Compact. This will help if you had lot of delete operations. If it still doesnt help then try normalising tables and avoid data redundancy.
Cheers,
Sri
Forum posts: 2
I try to Run RDbDatabase::Compact,It really work!Now,the file size become to be 10 pecents of the old one.
thank you very much!
Forum posts: 51
Under
» Symbian OS v9.1 » Symbian OS guide » System libraries » Using DBMS » Interface to DBMS databases » Database compression
there are some cues and notes