[B! sqlite] ryuusuijyoudouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ryuusuijyoudou id:ryuusuijyoudou

sqliteã«é–¢ã™ã‚‹ryuusuijyoudouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

places.sqliteãŒVACUUMã•ã‚Œã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚° - hogehoge @teramako
æ˜¨æ—¥Firefox SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®VACUUMã«ã¤ã„ã¦ - hogehogeã®è¨˜äº‹ã‚’æ›¸ãã€ Firefox3.6ã ã£ãŸã‹3.5ã ã£ãŸã‹ã§ã€places.sqliteã¯PCãŒã‚¢ã‚¤ãƒ‰ãƒ«æ™‚ã«VACUUMã™ã‚‹å‡¦ç†ãŒå…¥ã£ã¦ã„ã‚‹ã¯ãšã€‚ ã¨æ›¸ã„ãŸã€‚ ã¾ãŸã€ã‚³ãƒ¡ãƒ³ãƒˆæ¬„ã«ã¦Bug 512854 ? VACUUM places.sqlite database on daily idle once a monthã‚’æ•™ãˆã¦ã‚‚ã‚‰ã„ã€mozilla-1.9.2: changeset 31871:7b4f35e3a442ãŒãƒªãƒã‚¸ãƒˆãƒªã«ã‚³ãƒŸãƒƒãƒˆã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒåˆ†ã‹ã£ãŸã€‚ ã‚‚ã—ã‹ã™ã‚‹ã¨å‹˜é•ã„ã•ã‚Œã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã®ã§æ›¸ã„ã¦ãŠãã¨Firefox3.6ã§ã¯æ—¢ã«åæ˜ ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãã‚Œã ã‘ã˜ã‚ƒä½•ãªã®ã§ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã„ã¤ã©ã†ã„ã£ãŸæ¡ä»¶ã§VACUUMã•ã‚Œã‚‹ã‹èª¿ã¹ã¦ã¿ãŸã€‚ ã¾ãšã€FirefoxãŒèµ·å‹•ã™ã‚‹ã¨Placesã‚µ
ryuusuijyoudou 2010/07/30
Firefox

sqlite
ãƒªãƒ³ã‚¯
mozilla-1.9.2 @ 7b4f35e3a442
ryuusuijyoudou 2010/07/30
Firefox

sqlite
ãƒªãƒ³ã‚¯
Firefoxã®Placesãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¢ã‚¤ãƒ‰ãƒ«æ™‚é–“ã«vacuumã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ - Mozilla Flux
Placesã¯Firefoxã®å±¥æ´ã¨ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚’ä¿å˜ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€SQLiteã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ©ç”¨ã—ã¦ã€places.sqliteã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ã¦ã„ã‚‹ã€‚ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®è‚¥å¤§åŒ–ã¨æ–ç‰‡åŒ–ãŒFirefoxã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®æ‚ªåŒ–ã‚’æ‹›ãã¨ã¿ã‚‰ã‚Œã¦ãŠã‚Šã€å‰Šé™¤ã•ã‚Œã¦ç©ºã„ãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è©°ã‚ã¦å†é…ç½®ã™ã‚‹vacuumå‘½ä»¤ã«é–¢å¿ƒãŒé›†ã¾ã‚‹ã‚†ãˆã‚“ã ã€‚ ã—ã‹ã—ã€Firefoxã¯ã“ã®vacuumå‘½ä»¤ã‚’è‡ªå‹•çš„ã«ã¯ç™ºè¡Œã—ã¦ãã‚Œãªã„ã€‚ãã®ãŸã‚å±¥æ´ãƒ‡ãƒ¼ã‚¿ã‚„ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚’å‰Šé™¤ã—ã¦ã‚‚places.sqliteã®è‚¥å¤§åŒ–ãƒ»æ–ç‰‡åŒ–ã¯é€²ã‚€ä¸€æ–¹ã§ã‚ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“ã€å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã“ã®ã‚ˆã†ãªäº‹æ…‹ã‚’æœ›ã‚“ã§ãŠã‚‰ãšã€Firefoxã®é€Ÿåº¦ä½Žä¸‹ã‚’é˜²ãç°¡å˜ãªæ‰‹æ®µã‚’æ¬²ã—ã¦ã„ãŸã€‚ãˆã‚€ã‚‚ã˜ã‚‰ã€ŽFirefox ã® places.sqlite ã‚’å†èµ·å‹•ã›ãšã« VACUUM ã™ã‚‹æ–¹æ³•ã€ãŠã‚ˆã³ã€ŽPlaces ã‚’ VACUUM ã™ã‚‹æ‹¡å¼µæ©Ÿèƒ½3å€‹
ryuusuijyoudou 2010/07/30
Firefox

sqlite
ãƒªãƒ³ã‚¯
Firefox SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®VACUUMã«ã¤ã„ã¦ - hogehoge @teramako
ã¾ãŸã“ã®è©±ã‹ã€‚ã¨ã„ã†ã‹Firefoxã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒã‚¿ã¯å®šæœŸçš„ã«æŒ™ãŒã‚Šã¾ã™ãï½— Re:é•·æœŸé–“ã®ä½¿ç”¨ã§é‡ããªã£ãŸFirefoxã‚’ä¸€çž¬ã§è»½ãã™ã‚‹æ–¹æ³• (Kanasansoft Web Lab.) Twitterä¸Šã§ã„ãã¤ã‹ã‚„ã‚Šå–ã‚Šã—ãŸã‘ã©ã€åƒ•ã®è€ƒãˆã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ SQLiteã®VACUUMã¯è«–ç†ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ç›´ã™ã‚ˆã†ãªå‡¦ç†ã€‚å½“ç„¶ãƒ‡ãƒ¼ã‚¿é…ç½®ãŒå¤‰ã‚‹ã€‚ãã†ã™ã‚‹ã¨ã€ãã®ç´¢å¼•ã¯å…¨ãåˆ¥ã®è¡Œã‚’æŒ‡ã—ç¤ºã—ã¦ã—ã¾ã†ã‹ã‚‚ã—ã‚Œãªã„ã®ã§ç„¡æ„å‘³ãªç´¢å¼•ã«ãªã‚‹ã€‚VACUUMã¯å¯¾è±¡ãƒ†ãƒ¼ãƒ–ãƒ«ã«ä»˜ãç´¢å¼•ã‚‚ã‚»ãƒƒãƒˆã§å†æ§‹æˆã•ã‚Œã‚‹ã¨äºˆæƒ³ http://twitter.com/teramako/status/13823980384 ãªã®ã§ã€REINDEXã¯ã‚„ã‚‰ãªãã¦ã‚‚è‰¯ã„ã¨æ€ã£ã¦ã„ã‚‹ã€‚ãŸã ã€ãã®å¾ŒVACUUMã¨VACUUM+REINDEXã§ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºãŒå¤‰åŒ–ã—ãŸã¨ã„ã†å ±å‘Šã‚’é ‚ã„ã¦ã„ã‚‹ã®ã§ã€REINDEXã¾ã§ã‚„
ryuusuijyoudou 2010/07/30
Firefox

sqlite
ãƒªãƒ³ã‚¯
Firefoxã®ã‚¢ãƒ‰ã‚ªãƒ³ã€ŒSQLite Managerã€ã‚’ä½¿ã£ã¦Firefoxè‡ªä½“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æœ€é©åŒ–ã™ã‚‹
Windowsã®è©±ã€‚ã€€Mac OS Xã§ã‚ã‚Œã°sqlite3ãŒæ¨™æº–ã§å…¥ã£ã¦ã‚‹ã‚“ã§ã€(username).defaultã¾ã§ç§»å‹•ã—ã¨ã„ã¦ã€Œsqlite3 places.sqlite vacuumã€ã£ã¦ã™ã‚‹ã ã‘ã€‚ã€€vacuumã¯Mail.appãªã‚“ã‹ã§ã‚‚é‡å®ã™ã‚‹ã‚‰ã—ã„ã§ã™ãï¼ˆMail.appã¯ä½¿ã£ã¦ã„ãªã„ã®ã§ã‚¢ãƒ¬ã§ã™ã‘ã‚Œã©ã‚‚ï¼‰ã€‚ ã•ã¦ãŠãã€Windowsã§SQLiteã®Vacuumã‚’ã™ã‚‹ã‚“ã§ã‚ã‚Œã°ã€æœ¬å®¶ã§Windows Binariesã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã£ã¦ã®ã‚‚ã‚ã‚Šã¾ã™ãŒã€Firefoxã¯ã©ã“ã¾ã§ã™ã”ã„ã‚“ã ã‚ã†ã€ã€ŒSQLite Managerã€ã£ã¦ã„ã†ã‚¢ãƒ‰ã‚ªãƒ³ãŒã‚ã‚‹ã‚“ã§ã™ã‚ˆã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦Firefoxã‚’å†èµ·å‹•å¾Œã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã®ã€Œãƒ„ãƒ¼ãƒ«ã€ï¼žã€ŒSQLite Managerã€ã§ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ ã“ã“ã§ã¯Firefoxã®places.sqliteã‚’vacuumã—ã¦reindexã—ã¦ã¿ã¾
ryuusuijyoudou 2010/07/29
é«˜é€ŸåŒ–

sqlite

Firefox
ãƒªãƒ³ã‚¯
1