MySQL Forums
Forum List  »  PHP

Complex queries
Posted by: Taras Lesko
Date: March 01, 2014 02:42PM

Hello, I need advice for:
I use complex query like that: (can be 100 000 rows in table)

"SELECT
(SELECT count(*) as total FROM table WHERE ...) as leaners,
(SELECT count(*) as total FROM table WHERE ...) as courses,
(SELECT count(*) as total FROM table WHERE ...) as space,
(SELECT count(*) as total FROM table WHERE ...) as teachers,
(SELECT count(*) as total FROM table WHERE ...) as grages,
(SELECT count(*) as total FROM table WHERE ...) as logs,
(SELECT count(*) as total FROM table WHERE ...) as reports,
(SELECT count(*) as total FROM table WHERE ...) as modules,
(SELECT count(*) as total FROM table WHERE ...) as sections,
(SELECT count(*) as total FROM table WHERE ...) as groups"

is it better for server performance or NOT (use single query to get each result) ?

Options: ReplyQuote


Subject
Written By
Posted
Complex queries
March 01, 2014 02:42PM
March 01, 2014 11:28PM
May 26, 2014 11:32PM
May 27, 2014 02:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.