计算机系统应用
計算機繫統應用
계산궤계통응용
APPLICATIONS OF THE COMPUTER SYSTEMS
2014年
4期
193-196
,共4页
Android SQLite%性能优化%事务%索引
Android SQLite%性能優化%事務%索引
Android SQLite%성능우화%사무%색인
Android SQlite%performance optimization%transaction%index
SQLite是Android平台的重要数据库引擎，具有零配置、支持事务、移植性好等特点，负责多种格式数据的存储。随着用户数据规模的扩大与复杂度的增加，对数据库性能提出更高的要求。数据库性能直接影响应用程序的性能和用户的体验。本文分析了SQLite事务机制和索引结构，并通过手动添加事务和合理创建B-tree索引，大大缩短了Android SQLite数据库的插入与查询时间，提高了SQLite性能。
SQLite是Android平檯的重要數據庫引擎，具有零配置、支持事務、移植性好等特點，負責多種格式數據的存儲。隨著用戶數據規模的擴大與複雜度的增加，對數據庫性能提齣更高的要求。數據庫性能直接影響應用程序的性能和用戶的體驗。本文分析瞭SQLite事務機製和索引結構，併通過手動添加事務和閤理創建B-tree索引，大大縮短瞭Android SQLite數據庫的插入與查詢時間，提高瞭SQLite性能。
SQLite시Android평태적중요수거고인경，구유령배치、지지사무、이식성호등특점，부책다충격식수거적존저。수착용호수거규모적확대여복잡도적증가，대수거고성능제출경고적요구。수거고성능직접영향응용정서적성능화용호적체험。본문분석료SQLite사무궤제화색인결구，병통과수동첨가사무화합리창건B-tree색인，대대축단료Android SQLite수거고적삽입여사순시간，제고료SQLite성능。
SQLite is an important database engine on Android platform. It has features of zero-configuration, supporting transactions and excellent portability. And it is responsible for multiple formats of data storage. With the expansion and complexity of the user data, there is higher demand upon the SQLite performance which may affect the performance of the application program and the user experience. This paper analyzes the transaction mechanism and the index structure of SQLite. By means of turning on transaction manually and creating B-tree index properly, it greatly reduces the time needed to insert and query data from Android SQLite, which improves SQLite performance ultimately.
