摘要
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.
出处
《计算机系统应用》
2014年第4期193-196,共4页
Computer Systems & Applications
关键词
性能优化
事务
索引
Android SQLite
Android SQlite
performance optimization
transaction
index