t0m3kk: Managing #Hierarchical Data in #MySQL - Преди няколко дни един колега ми обясняваше модела и сега зачетох и статията, доста доволно :)

Вход

Начало Потребители Групи

Следващ пост Профил на t0m3kk Предишен пост

t0m3kk

Managing #Hierarchical Data in #MySQL - Преди няколко дни един колега ми обясняваше модела и сега зачетох и статията, доста доволно

Oct 28 2012, 20:49

Facebook

DB Queries: 10 (0.0062s) | CACHE Queries: 17 (0.0016s) | Script Execution Time: 0.010 | Memory usage: 0.89MB | Server Load Average: 0.17, 0.11, 0.1

0.00028	SELECT * FROM posts_comments WHERE post_id="1436472" ORDER BY id ASC
0.00023	SELECT id, type, data FROM posts_attachments WHERE post_id="1436472" LIMIT 1
0.00036	SELECT * FROM posts WHERE id<"1436538" AND user_id="6742" ORDER BY id DESC LIMIT 1
0.00032	SELECT * FROM posts_comments WHERE post_id="1438490" ORDER BY id ASC
0.00273	SELECT * FROM posts WHERE id>"1436538" AND user_id="6742" ORDER BY id ASC LIMIT 1
0.00024	SELECT id FROM groups WHERE is_public=0
0.00032	SELECT id, type, data FROM posts_attachments WHERE post_id="1436538" LIMIT 1
0.00026	SELECT * FROM posts WHERE id="1436538" LIMIT 1
0.00028	SELECT * FROM settings
0.00121	CONNECT 49.12.223.183:9906