리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, rootman, http://www.rootman.co.kr
* 54.160.19.155 *
| Home | Profile | Linux | 자료실 | zabbix | Mysql 5.6 | 갤러리 | 성경검색 | 해피니스 | 자유게시판 | 게시물검색 | L | O | R |    

 
[sqlite] [sqlite] I deleted a lot of data but the database file did not get any smaller. Is this a bug?
 작성자 : rootman
Date : 2011-10-28 13:41  |  Hit : 4,872  

No. When you delete information from an SQLite database, the unused disk space is added to an internal "free-list" and is reused the next time you insert data. The disk space is not lost. But neither is it returned to the operating system.

If you delete a lot of data and want to shrink the database file, run the VACUUM command. VACUUM will reconstruct the database from scratch. This will leave the database with an empty free-list and a file that is minimal in size. Note, however, that the VACUUM can take some time to run (around a half second per megabyte on the Linux box where SQLite is developed) and it can use up to twice as much temporary disk space as the original file while it is running.

As of SQLite version 3.1, an alternative to using the VACUUM command is auto-vacuum mode, enabled using the auto_vacuum pragma.


 
 

Total. 19
번호 분류 제목 작성자 등록일 조회수
19 sqlite [sqlite3] 날짜와 시간 함수 알아보기 rootman 12-14 11517
18 sqlite [sqlite3] command, DB 전체를 dump export, dump import 하기 rootman 12-12 5803
17 sqlite [sqlite3] command, 외부로 import/export하기 rootman 12-12 5221
16 sqlite [sqlite] 유용한 함수들 rootman 11-22 8272
15 sqlite [sqlite] 반올림, 버림, 올림 함수 rootman 11-22 11758
14 sqlite [sqlite] I deleted a lot of data but the database file did n… rootman 10-28 4873
13 sqlite [sqlite] How do I add or delete columns from an existing tab… rootman 10-28 4876
12 sqlite [sqlite] Collation Sequence Examples rootman 10-28 5183
11 sqlite [sqlite] Assigning Collating Sequences from SQL rootman 10-28 4975
10 sqlite [sqlite] Collating Sequences rootman 10-28 4750
9 sqlite [sqlite] Sorting, Grouping and Compound SELECTs rootman 10-28 4860
8 sqlite [sqlite] Operators rootman 10-28 4760
7 sqlite [sqlite] Comparison Example rootman 10-28 4897
6 sqlite [sqlite] Type Conversions Prior To Comparison rootman 10-28 4918
5 sqlite [sqlite] Affinity Of Comparison Operands rootman 10-28 4969
 1  2  
AND OR