ÇѱÛÁ¦¸ñ(Korean Title) |
Atomic Write¸¦ È°¿ëÇÑ SQLite ÃÖÀûÈ |
¿µ¹®Á¦¸ñ(English Title) |
SQLite Optimization with Atomic Write |
ÀúÀÚ(Author) |
±èÇüµæ
Hyung-deuk Kim
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 21 NO. 02 PP. 0107 ~ 0110 (2017. 10) |
Çѱ۳»¿ë (Korean Abstract) |
¿©·¯ ¿¬±¸¿¡ µû¸£¸é ÀÓº£µðµå µð¹ÙÀ̽º¿¡¼ ÇÁ·Î¼¼¼ ¹× ³×Æ®¿öÅ©ÀÇ ¼Óµµ´Â »ç¿ëÀÚÀÇ ¿ä±¸»çÇ×À» ÃæÁ·½Ãų ¸¸Å ºü¸¥µ¥ ¹ÝÇØ IO ¼Óµµ°¡ ¼º´ÉÀÇ ÁÖ¿ä º´¸ñÀ¸·Î ¹àÇôÁø ¹Ù ÀÖ´Ù. ¶ÇÇÑ ÀÌ·± IO º´¸ñ Çö»óÀÇ 70% ÀÌ»óÀÌ SQLite µ¥ÀÌÅͺ£À̽º¿Í °ü·ÃµÈ Çö»óÀ¸·Î ¹àÇôÁ³´Ù. À̸¦ ÇØ°áÇϱâ À§ÇÑ SQLite ¼º´É ÃÖÀûÈ °ü·Ã ¿¬±¸µéÀº ¾²±â IO¿¡ ÃÖÀûÈµÈ Àú³Î ¹æ½ÄÀÎ WAL ¹æ½Ä Áß½ÉÀÇ ¿¬±¸µéÀÌ ´Ù¼ö¸¦ ÀÌ·ç°í ÀÖ´Ù. º» ³í¹®¿¡¼´Â Android¿Í Tizen¿¡¼ ÁÖ·Î »ç¿ëµÇ´Â Rollback Àú³Î ¹æ½Ä ȯ°æ ÇÏ¿¡¼ ¼º´É¹®Á¦ ÇØ°áÀ» À§ÇÑ SQLite Atomic Write ±â¹ýÀ» Á¦¾ÈÇÑ´Ù. Á¦¾ÈÇÑ ±â¹ýÀ» ÅëÇØ ÆÄÀÏ ¾²±â, µ¿±âÈ ÀÛ¾÷À» ÁÙÀÓÀ¸·Î½á ¾²±â ¼º´É(300%)°ú ¸Þ¸ð¸® »ç¿ë·®(80%)ÀÌ Çâ»ó µÈ °ÍÀ» È®ÀÎÇÒ ¼ö ÀÖ¾ú°í JOJ(Àú³Î¸µ ÆÄÀÏ¿¡ ´ëÇÑ Àú³Î¸µ) Çö»óÀ» ¸·°í Ç÷¡½Ã ¸Þ¸ð¸®ÀÇ ¼ö¸íÀ» ´Ã¸± ¼ö ÀÖ´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
According to researches, while the speed of processor and network in embedded devices is fast enough to meet user requirement, the IO speed is recognized as the main performance bottleneck. Meanwhile it is known that more than 70 percent of IOs are issued from SQLite database. Many researches related SQLite performance optimization is based on WAL mode because WAL mode optimized for write IO performance. In this paper, I propose to optimize SQLite with Atomic Write in the Rollback Journal Mode, which is mainly used in Android and Tizen. I have observed that Atomic Write have a significant write performance improvement(300%) by reducing write, file sync operation and memory usage improvement(80%). Additionally it can block JOJ(Journaling of Journal) and extend the life of the flash memory.
|
Å°¿öµå(Keyword) |
SQLite
Atomic Write
Àú³Î
ÃÖÀûÈ
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|