[B! database][SQL] somatã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

somat id:somat

databaseã¨SQLã«é–¢ã™ã‚‹somatã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{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}}

DBIx::ProfileManager ã§ SQL Profiling | BLOG - DeNA Engineering
é¢¨é‚ªã‚’å¼•ãã£ã±ãªã—ã§å…¨ç„¶æ²»ã‚‰ãªã„å±±å£ã§ã™ã€‚æã‚‰ããƒãƒƒãƒˆä¸Šã§ã¯ zigorou ã¨è¨€ã†ãƒãƒ³ãƒ‰ãƒ«ã§ã”å˜çŸ¥ã®æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ãšã¯æŠ€è¡“ç³»ã®ãƒã‚¿ã®ç¬¬1å¼¾ã§ã™ã€‚ ä»Šå›žã¯å®Ÿéš›ã«ãƒ¢ãƒã‚²ãƒ¼ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ç”¨ã„ã¦ã„ã‚‹ SQL Profiling ã®æ–¹æ³•ã‚’ã”ç´¹ä»‹è‡´ã—ã¾ã™ã€‚ DBI::Profile ã«ã¤ã„ã¦ ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ MySQL ã‚’ç”¨ã„ã¦ãŠã‚Šã€ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ç®¡ç†ãƒ„ãƒ¼ãƒ«ã¾ã§ã®ã»ã¨ã‚“ã©ãŒ Perl ã§æ›¸ã‹ã‚Œã¦ãŠã‚Šã€ å½“ç„¶ãªãŒã‚‰ DBI ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¾ãŸã¯ãã‚Œã‚’åˆ©ç”¨ã—ãŸãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ DB ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã€ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãƒãƒ¼ãƒ ã§ä½œã£ãŸ OpenSocial RESTful API ã§ã™ãŒã€ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³å†…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¤§é‡ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ç‚ºã«æ—¥ã€…ã©ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•ã‚Œã€ã©ã‚Œãã‚‰ã„ã®å®Ÿè¡Œæ™‚é–“ãŒæŽ›ã‹ã£ã¦ã„ã‚‹ã‹ã¯å¸¸ã«æ°—ã«ãªã‚‹
somat 2013/10/28
SQL

Perl

CPAN

database

performance

profiling
ãƒªãƒ³ã‚¯
Slow Query Questions - PostgreSQL wiki
Guide to Asking Slow Query Questions In any given week, some 50% of the questions on #postgresql IRC and 75% on pgsql-performance are requests for help with a slow query. However, it is rare for the requester to include complete information about their slow query, frustrating both them and those who try to help. Please post performance related questions to the pgsql-performance mailing list or to
somat 2012/05/29
ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã«ã¤ã„ã¦è³ªå•ã™ã‚‹ã¨ãã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã€‚æä¾›ã™ã¹ãæƒ…å ±ã€èžãå‰ã«ã‚„ã‚‹ã¹ãã“ã¨(EXPLAINã®çµæžœã‚ˆã‚€, ANALYZE/VACUUM, work_mem ã®å¢—æ¸›ç‰)

PostgreSQL

SQL

database

performance
ãƒªãƒ³ã‚¯
Reading PgAdmin Graphical Explain Plans - Postgres OnLine Journal
One of our favorite features of PgAdmin is the graphical explain plan feature. While a graphical explain plan is not a complete substitute for EXPLAIN or EXPLAIN ANALYZE text plans, it does provide a quick and easy to read view that can be used for further analysis. In this article, we'll walk thru using the explain plan to troubleshoot query performance. To use the graphical explain plan feature
somat 2012/04/26
PostgreSQL

performance

database

pgAdmin

SQL
ãƒªãƒ³ã‚¯
SQLã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ è¨˜äº‹ä¸€è¦§ | gihyo.jp
æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ5ï¼‰é›†åˆæŒ‡å‘ã¨æ‰‹ç¶šãåž‹ ãƒŸãƒƒã‚¯ 2010-05-28 æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ4ï¼‰OLAPé–¢æ•°ã¨é›†ç´„é–¢æ•°ã‚’çµ„ã¿åˆã‚ã›ã‚‹ ãƒŸãƒƒã‚¯ 2010-05-27
somat 2012/04/26
database

performance

PostgreSQL

SQL
ãƒªãƒ³ã‚¯
PostgreSQL tuning technique
PostgreSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯é›† SELECT ... WHERE foo = 100 ORDER BY barã‚’SELECT ... WHERE foo = 100 ORDER BY i, jã«æ›¸ãæ›ãˆã‚‹(2004/08/18æŽ²è¼‰) SELECT * FROM t1 WHERE i = 100 ORDER BY j; ã®ã‚ˆã†ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã®æ¤œç´¢ã§ã¯ï¼Œiã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§ã‚ã‚‹ç¨‹åº¦ã®é«˜ é€ŸåŒ–ãŒã§ãã¾ã™ãŒï¼Œãã®å¾Œã§ã‚½ãƒ¼ãƒˆãŒç™ºç”Ÿã—ï¼Œé€Ÿåº¦ä½Žä¸‹ã®è¦å› ã«ãªã‚Šã¾ã™ï¼Ž SELECT * FROM t1 WHERE i = 100 ORDER BY j LIMIT 5; ã®ã‚ˆã†ã«ï¼Œå‡ºåŠ›çµæžœä»¶æ•°ã‚’åˆ¶é™ã—ã‹ã¤jã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã¨ï¼Œä»Šåº¦ã¯jã®ã‚¤ ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼Ž ã—ã‹ã—ï¼Œã‚ˆãè€ƒãˆã¦ã¿ã‚‹ã¨ï¼Œiã§æ¤œç´¢ã—ï¼Œjã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã¯iã¨jã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã®ä¸¡æ–¹ã‚’ä½¿ãˆã°ä¸€åº¦ã«ã§ãã‚‹ã¯ãšã§ã™
somat 2012/04/11
ã‚·ãƒ¼ãƒ©ã‚«ãƒ³ã‚¹æœ¬ç¬¬4ç‰ˆã®ã‚µãƒ–ãƒšãƒ¼ã‚¸ / 1.æ¤œç´¢æ¡ä»¶ã¨order by ã«ä½¿ã†ã‚«ãƒ©ãƒ ã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹/ 2.group by æŒ‡å®šã§ HashAggregate ã¤ã‹ã‚ã›ã‚‹

PostgreSQL

database

tips

performance

SQL
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ9ï¼‰
å›³10â—ãƒ¬ã‚³ãƒ¼ãƒ‰ãƒ»ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã®ä»•çµ„ã¿ã€‚ãƒãƒƒã‚·ãƒ¥å€¤ã«ã—ãŸãŒã£ã¦ï¼Œempã¨emp_histã®äºŒã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã§åŒã˜enoã‚’æŒã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸€ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã—ã¦ã„ã‚‹ RDBMSãŒå‚™ãˆã‚‹ã•ã¾ã–ã¾ãªé«˜é€ŸåŒ–æ‰‹æ³• RDBMSã¯ï¼Œã“ã“ã¾ã§èª¬æ˜Žã—ã¦ããŸåŸºæœ¬çš„ãªãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã®ã—ã‹ãŸã‚„æ“ä½œæ–¹æ³•ã«åŠ ãˆï¼Œé«˜é€ŸåŒ–ã®ãŸã‚ã®æ‰‹æ³•ã‚’ã„ã‚ã„ã‚ç”¨æ„ã—ã¦ã„ã¾ã™ã€‚Part2ã®æœ€å¾Œã«ï¼Œã“ã‚Œã‚‰ã®æ‰‹æ³•ã‚’ã–ã£ã¨ç´¹ä»‹ã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ â—ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ»ãƒãƒƒãƒ•ã‚¡ã®ã‚µã‚¤ã‚ºã‚„ä½¿ã‚ã‚Œæ–¹ã«ã‚‚ã‚ˆã‚Šã¾ã™ãŒï¼Œä¸€èˆ¬ã«Bãƒ„ãƒªãƒ¼ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦å·¨å¤§ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹éš›ã«ã¯ï¼Œãƒ«ãƒ¼ãƒˆãƒ»ãƒŽãƒ¼ãƒ‰ã ã‘ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ»ãƒãƒƒãƒ•ã‚¡ã«ã‚ã‚‹ã®ãŒæ™®é€šã§ã™ã€‚ãã®ãŸã‚ï¼Œãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãŸã©ã‚Šã¤ãã¾ã§ã«ãƒ–ãƒ©ãƒ³ãƒãƒ»ãƒŽãƒ¼ãƒ‰ï¼Œãƒªãƒ¼ãƒ•ãƒ»ãƒŽãƒ¼ãƒ‰ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ä½•å›žã‚‚ãƒ‡ã‚£ã‚¹ã‚¯ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã‚’1å›žã®ã‚¢ã‚¯ã‚»ã‚¹ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã§ãã‚‹ã‚ˆã†ã«ã—ã‚ˆ
somat 2012/04/11
ãƒãƒƒã‚·ãƒ¥ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

database

SQL
ãƒªãƒ³ã‚¯
ç¬¬7å›žã€€æ€§èƒ½æ”¹å–„ã®éµã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ç‰¹æ€§ã‚’çŸ¥ã‚‹ï½žB-treeã¨ãƒãƒƒã‚·ãƒ¥ã€€ï¼ˆ1ï¼‰B-tree | gihyo.jp
SQLã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ ç¬¬7å›žæ€§èƒ½æ”¹å–„ã®éµã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ç‰¹æ€§ã‚’çŸ¥ã‚‹ï½žB-treeã¨ãƒãƒƒã‚·ãƒ¥ã€€ï¼ˆ1ï¼‰B-tree ã¯ã˜ã‚ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ä»•äº‹ã‚’ã—ã¦ã„ã‚‹ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å•é¡Œã«æ‚©ã¾ã•ã‚Œã‚‹ã“ã¨ã¯æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã€‚ã¨ãã«æœ€è¿‘ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿é‡ãŒé£›èºçš„ã«å¢—ãˆã€ã‚µãƒ¼ãƒã®CPUã‚„ãƒ¡ãƒ¢ãƒªã¨ã„ã£ãŸãƒãƒ¼ãƒ‰é¢ã®å¢—å¼·ã ã‘ã§ã¯è¿½ã„ã¤ã‹ãªã„ã“ã¨ã‚‚å¤šãã‚ã‚Šã¾ã™ã€‚ ãã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ã«å¯¾å¿œã™ã‚‹ãŸã‚ã€DBMSã¯æ€§èƒ½æ”¹å–„ã®ãŸã‚ã®æ‰‹æ®µã‚’å¤šãç”¨æ„ã—ã¦ã„ã¾ã™ã€‚ãã®ä¸ã§æœ€ã‚‚ã‚³ã‚¹ãƒˆãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è‰¯ã„æ–¹æ³•ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆç´¢å¼•ï¼‰ã§ã™ã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚‚ãƒãƒ¼ãƒ‰æ§‹æˆã«ã‚‚å½±éŸ¿ã‚’ä¸Žãˆãšã«å®Ÿè¡Œã§ãã€ã†ã¾ãã„ã‹ãªã‘ã‚Œã°ã™ãã«å‰Šé™¤ã§ãã‚‹ã¨ã„ã†æ‰‹è»½ã•ãŒå¤§ããªé…åŠ›ã§ã€åŠ¹æžœã¯ã—ã°ã—ã°çµ¶å¤§ã§ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¯ã„ã‚ã„ã‚ãªç¨®é¡žãŒã‚ã‚Šã€ã¾ãŸDBMSã«ã‚ˆã£ã¦ã‚‚ã‚µãƒãƒ¼ãƒˆã™ã‚‹ç¨®é¡žã«å·®ãŒã‚ã‚Šã¾ã™ãŒã€æœ¬ç¨¿ã§ã¯æœ€ã‚‚é‡è¦ãª2ã¤ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚ãã‚Œ
somat 2012/04/11
SQL

database
ãƒªãƒ³ã‚¯
ç¬¬4å›žã€€ã‚¯ã‚¨ãƒªè©•ä¾¡ã‚¨ãƒ³ã‚¸ãƒ³ã¨å®Ÿè¡Œè¨ˆç”»â€•â€œã‚·ã‚§ãƒ•ãŠã¾ã‹ã›â€ã¯ã„ã¤ã‚‚ç¾Žå‘³ã—ã„ã®ã‹ï¼ˆ3ï¼‰ | gihyo.jp
å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã™ã‚‹å¯¾è±¡ã®ã‚¯ã‚¨ãƒªã¯ã€æ¬¡ã®ã‚ˆã†ãªäºˆç´„ã®å˜åœ¨ã™ã‚‹åº—èˆ—ã‚’é¸æŠžã™ã‚‹SELECTæ–‡ã§ã™ã€‚ SELECT shop_name FROM Shops S INNER JOIN Reservations R ON S.shop_id = R.shop_id; çµåˆã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ä¸€èˆ¬çš„ã«ã€DBMSãŒçµåˆã‚’è¡Œã†ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã¯3ç¨®é¡žã‚ã‚Šã¾ã™ã€‚æœ€ã‚‚åŸºæœ¬çš„ã§ã‚·ãƒ³ãƒ—ãƒ«ãªã®ãŒNested Loopã§ã™ã€‚ç‰‡æ–¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’èªã¿è¾¼ã¿ã€ãã®1ã¤ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ã€çµåˆæ¡ä»¶ã«åˆè‡´ã™ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã‚‚ã†ä¸€æ–¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰èªã¿è¾¼ã¿ã¾ã™ã€‚æ‰‹ç¶šãåž‹è¨€èªžã§æ›¸ãã¨äºŒé‡ãƒ«ãƒ¼ãƒ—ã§å®Ÿè£…ã™ã‚‹ã®ã§ã€ã“ã®åå‰ãŒã‚ã‚Šã¾ã™ã€‚ 2ã¤ç›®ã¯ã€Sort Merge[9]ã§ã™ã€‚çµåˆã‚ãƒ¼ï¼ˆä»Šã®ã‚±ãƒ¼ã‚¹ã§ã¯åº—èˆ—IDï¼‰ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã‚½ãƒ¼ãƒˆã—ã¦ã‹ã‚‰ã€é †æ¬¡ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¡Œã£ã¦2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã—ã¾ã™ã€‚çµåˆã®å‰å‡¦ç†ã¨ã—ã¦å¿…ãšã‚½ãƒ¼ãƒˆã‚’è¡Œã†ã®ã§ã€ãã®ãŸã‚ã®é ˜åŸŸã‚’å¿…è¦ã¨ã—ã¾ã™ã€‚
somat 2012/04/11
Oracle, MySQL, PostgreSQL ã§ã®çµåˆ

database

SQL
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰
å›³4â—ãƒã‚¹ãƒˆãƒ»ãƒ«ãƒ¼ãƒ—çµåˆã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«Aã®å„ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ã¤ã„ã¦ãƒ†ãƒ¼ãƒ–ãƒ«Bã®ã™ã¹ã¦ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨æ¯”è¼ƒã—ã¾ã™ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çµ±è¨ˆæƒ…å ±ã¯å®šæœŸçš„ã«æ›´æ–°ã™ã‚‹ åŸºæœ¬çš„ã«ã¯ï¼Œã»ã¨ã‚“ã©ã®å ´åˆã«ã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒãƒ¼ãƒã«åŸºã¥ãã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯æœ€é©ãªå®Ÿè¡Œè¨ˆç”»ã‚’é¸æŠžã—ã¦ãã‚Œã‚‹ã¨è€ƒãˆã¦ã•ã»ã©å•é¡Œã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãŸã ï¼Œã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ã®åŸºã«ãªã‚‹ã‚³ã‚¹ãƒˆã®è¨ˆç®—ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®å€¤ãŒå‡ç‰ã«åˆ†å¸ƒã—ã¦ã„ã‚‹ã¨ä»®å®šã—ã¦è¡Œã„ã¾ã™ã€‚ãã®ãŸã‚ï¼Œãƒ‡ãƒ¼ã‚¿ã®åˆ†å¸ƒã«æ¥µç«¯ãªåã‚ŠãŒã‚ã‚‹å ´åˆãªã©ã¯ï¼Œå®Ÿéš›ã«ã¯å…¨ä»¶èµ°æŸ»ã®ã»ã†ãŒå‡¦ç†ã¯æ—©ãçµ‚ã‚ã‚‹ã®ã«ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¤œç´¢ã‚’é¸æŠžã—ã¦ã—ã¾ã†ã‚ˆã†ãªå ´åˆã‚‚ã‚ã‚Šå¾—ã¾ã™ã€‚ ã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦åŠ¹çŽ‡ã®è‰¯ã„å®Ÿè¡Œè¨ˆç”»ã‚’ç«‹ã¦ã‚‹ã«ã¯ï¼Œå®šæœŸçš„ã«çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã™ã‚‹ã“ã¨ãŒé‡è¦ãªãƒã‚¤ãƒ³ãƒˆã¨ãªã‚Šã¾ã™ã€‚çµ±è¨ˆæƒ…å ±ã¯ï¼Œã‚ãã¾ã§ã‚‚ãã‚Œã‚’ä½œæˆã—ãŸã¨ãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çŠ¶æ…‹ã‚’åæ˜ ã—ã¦ã„ã¾ã™ã€‚ã—ãŸãŒã£ã¦ï¼Œçµ±è¨ˆæƒ…å ±ã‚’ä½œæˆã—ãŸå¾Œã«ãƒ‡ãƒ¼ã‚¿
somat 2012/04/11
"SQLæ–‡ã®å‡¦ç†ã«ã¯ï¼Œå¤§ããåˆ†ã‘ã¦ï¼Œé¸æŠžï¼Œå°„å½±ï¼Œçµåˆã®3ç¨®é¡žãŒã‚ã‚Šã¾ã™ãŒï¼Œæœ€ã‚‚è² è·ãŒå¤§ãã„ã®ãŒã“ã®çµåˆå‡¦ç†", "ã€Œãƒã‚¹ãƒˆãƒ»ãƒ«ãƒ¼ãƒ—çµåˆã€ã€Œãƒžãƒ¼ã‚¸çµåˆã€ã€Œãƒãƒƒã‚·ãƒ¥çµåˆã€ã®ä¸‰ã¤"

database

SQL
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
somat 2012/03/29
SQL

performance

tips

database

PostgreSQL
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬3å›žï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒ (1/4) -at- å¾¹åº•æ¯”è¼ƒ!! PostgreSQL vs MySQL
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã¯ã€PostgreSQLã¨MySQLï¼‹InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã§ã‚ã‚Šã€MySQLï¼‹MyISAMã‚¨ãƒ³ã‚¸ãƒ³ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã›ã‚“ã€‚ã“ã“ã§ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¨ã¯ã€è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å½±éŸ¿ã‚’ãŠã‚ˆã¼ã™å‡¦ç†ã‚’1ã¤ã®å˜ä½ã¨ã¿ãªã—ã€ã“ã®å˜ä½ã§ã®å‡¦ç†çµæžœã‚’ä¿è¨¼ã™ã‚‹æ©Ÿèƒ½ã‚’æŒ‡ã—ã¾ã™ã€‚ å…·ä½“çš„ã«ã¯ã€BEGINæ–‡ã«ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã—ã¦ã„ãã¤ã‹ã®å‡¦ç†ã‚’è¡Œã£ãŸå¾Œã€å‡¦ç†ã‚’ç¢ºå®šã™ã‚‹å ´åˆã¯COMMITæ–‡ã€å‡¦ç†ã‚’å–ã‚Šæ¶ˆã™å ´åˆã¯ROLLBACKæ–‡ã‚’ä½¿ç”¨ã—ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’çµ‚äº†ã•ã›ã‚‹ã¾ã§ã®å‡¦ç†ã§ã™ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã¯ã€è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåŒæ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸå ´åˆã«ã€ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®å½±éŸ¿ãŒã©ã®ãã‚‰ã„åˆ†é›¢ã™ã‚‹ã‹ã®ãƒ¬ãƒ™ãƒ«ã‚’æ„å‘³ã—ã¾ã™ã€‚ ANSI/ISO SQLè¦æ ¼ï¼ˆSQL92ï¼‰ã§ã¯4ã¤ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï¼ˆä¸‹è¨˜ã‚³ãƒ©ãƒ å‚ç…§ï¼‰ãŒå®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚P
somat 2011/08/29
PostgreSQL

database

SQL

Mysql
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
somat 2011/08/11
database

PostgreSQL

SQL
ãƒªãƒ³ã‚¯
1