35% Faster Than The Filesystem
1. Summary SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite(). Furthermore, a single SQLite database holding 10-kilobyte blobs uses about 20% less disk space than storing the blobs in individual files. The performance difference arises (we believe) because when working
SQLite Documentation
▼ Document Lists And Indexes Alphabetical Listing Of All Documents Website Keyword Index Permuted Title Index ► Overview Documents About SQLite → A high-level overview of what SQLite is and why you might be interested in using it. Appropriate Uses For SQLite → This document describes situations where SQLite is an appropriate database engine to use versus situations where a client/server database e
Architecture of SQLite
Introduction This document describes the architecture of the SQLite library. The information here is useful to those who want to understand or modify the inner workings of SQLite. Interface SQL Command Processor Virtual Machine B-Tree Pager OS Interface Tokenizer Parser Code Generator Utilities Test Code Core Backend SQL Compiler Accessories A nearby diagram shows the main components of SQLite and
SQLiteã®ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¯4567万8000è¡Œï¼ æœ¬ä½“ã®ã‚³ãƒ¼ãƒ‰ã¯6万7000è¡Œ
軽é‡ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦äººæ°—ã®SQLite。ãã®Webサイトã«æŽ²è¼‰ã•ã‚Œã¦ã„る「How SQLite Is Testedã€ã®å†…容ãŒã€æµ·å¤–ã®ãƒ—ãƒã‚°ãƒ©ãƒžãªã©ã®ã‚ã„ã ã§è©±é¡Œã«ãªã£ã¦ã„ã¾ã™ã€‚ 3月ã«å…¬é–‹ã•ã‚ŒãŸæœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®SQLite 3.6.23。本体ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ç´„6万7200行（67.2KSLOCã€Kilo Source Lines of Code：空行やコメントを除ã„ãŸè¡Œæ•°ï¼‰ãªã®ã«å¯¾ã—ã€ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¯ãªã‚“ã¨4567万8300行（45678.3KSLOC）ã ã¨ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ã™ï¼ ã“ã‚Œã¯ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ãŒæœ¬ä½“ã®ç´„679å€ã‚‚ã®å¤§ãã•ã ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ 100ï¼…ã®ãƒ–ランãƒã‚«ãƒãƒ¬ãƒƒã‚¸ SQLiteコアã®ãƒ©ã‚¤ãƒ–ラリをテストã™ã‚‹ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¨ã—ã¦ã€ä»¥ä¸‹ã®3ã¤ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ TCL Tests TCL Testsã¯ã‚‚ã£ã¨ã‚‚å¤ã„テストコードã§ã€TCL scripting lang
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Electronã§sqlite3を使ã£ãŸã‚¢ãƒ—リ | | Scimpr Blog
How Does a Database Work?
http://www.cpa-lab.com/tech/046
{{#tags}}- {{label}}
{{/tags}}