Acceleration of the application "SMS / MMS" on the Iphone

All the happy owners of this device and actively (or not) reading and writing sms, sooner or later face the fact that when opening the SMS application itself, it ooooochen loads for a long time. However, perhaps not many people know that this can be corrected !;)
However, unfortunately, this possibility is only on jailbroken phones.
If in brief, the essence is as follows: the sms database in the iPhone is stored as a normal sqlite database. Therefore, you just need to take the database file and clean the database using vacuum. Since on the iPhone itself there are no utilities for working with sqlite databases, you need to download the file to your computer and run vacuum using any sqlite program.

For reference: The VACUUM command cleans the database by copying the contents into a temporary database file and then reloading the data into the database. This procedure eliminates blank pages, builds data sequentially, and also cleans the database file structure.

Under * nix / MacOS, the simplest algorithm is as follows:
0) Run ssh on the phone, if suddenly it is not running.
1) Go to the phone via ssh under the root.
2) Go to / var / mobile / Library / SMS: #cd / var / mobile / Library / SMS.
3) Just in case, back up the file: cp sms.db sms.db.old.
4) Copy this file to your computer using scp: #scp sms.db Your_login @ IP_comp: ~ /.
5) We repair the sms database on our computer:> sqlite3 ~ / sms.db vacuum
6) Fill it back: scp Your_login @ IP_kompa: ~ / sms.db ./
')
Voila! :)

For example:
On my iPhone (2g) with the number of SMS = 4300, the download time before this procedure was ~ 12 seconds, after cleaning it was reduced to ~ 4 seconds.