svil4ok: MongoDB vs MySQL

Вход

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

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

svil4ok

MongoDB vs MySQL

Aug 03 2011, 16:12

Прикачено видео:

Facebook

DB Queries: 12 (0.0051s) | CACHE Queries: 16 (0.0016s) | Script Execution Time: 0.009 | Memory usage: 0.85MB | Server Load Average: 0.23, 0.24, 0.16

0.00028	SELECT * FROM users_details WHERE user_id="15535" LIMIT 1
0.00035	SELECT * FROM users WHERE id="15535" LIMIT 1
0.00026	SELECT user_id FROM posts_reshares WHERE post_id="1390326" ORDER BY id DESC LIMIT 1
0.00026	SELECT id, type, data FROM posts_attachments WHERE post_id="1390326" LIMIT 1
0.00040	SELECT * FROM posts WHERE id<"1390369" AND user_id="471" ORDER BY id DESC LIMIT 1
0.00026	SELECT id, type, data FROM posts_attachments WHERE post_id="1390570" LIMIT 1
0.00069	SELECT * FROM posts WHERE id>"1390369" AND user_id="471" ORDER BY id ASC LIMIT 1
0.00030	SELECT id FROM groups WHERE is_public=0
0.00037	SELECT id, type, data FROM posts_attachments WHERE post_id="1390369" LIMIT 1
0.00030	SELECT * FROM posts WHERE id="1390369" LIMIT 1
0.00033	SELECT * FROM settings
0.00132	CONNECT 49.12.223.183:9906