| |
|
|
| |
SELECT COUNT(*) as c FROM dle_post
UNION ALL
SELECT COUNT(*) FROM dle_post
WHERE date > CURRENT_DATE
UNION ALL
SELECT COUNT(*) FROM dle_post
WHERE date > NOW() - INTERVAL 1 MONTH
UNION ALL
SELECT COUNT(*) FROM dle_users
WHERE reg_date > UNIX_TIMESTAMP(CURRENT_DATE)
UNION ALL
SELECT COUNT(*) FROM dle_users
WHERE reg_date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 MONTH)
UNION ALL
SELECT COUNT(*) FROM dle_users
|
этот запрос будет быстрее работать чем, каждый по отдельности?
SELECT COUNT(*) as count FROM " . PREFIX . "_post
SELECT COUNT(*) as count FROM " . PREFIX . "_post where date>NOW() - INTERVAL 1 DAY;
SELECT COUNT(*) as count FROM " . PREFIX . "_post where date>NOW() - INTERVAL 1 MONTH;
SELECT COUNT(*) as count FROM " . PREFIX . "_users where FROM_UNIXTIME(reg_date) > NOW() - INTERVAL 1 DAY;
SELECT COUNT(*) as count FROM " . PREFIX . "_users where FROM_UNIXTIME(reg_date) > NOW() - INTERVAL 1 MONTH;
SELECT COUNT(*) as count FROM " . PREFIX . "_users
|
Заранее спасибо! | |
| |
|
|
| |
|
|
| |
для: cernos
(30.05.2006 в 11:44)
| | | >этот запрос будет быстрее работать чем, каждый по отдельности?
Вряд ли... | |
| |
|
|
