I have a question regarding query execution time.
I have one table with call log data. Total number of rows = 1,037,104,310
When I do aggregated functions like COUNT, MIN, MAX against entire data set, query execution is very fast = 0.0212s
However when I do COUNT GROUPED BY CALL CONNECT DATE, query takes about 200-300 seconds. Query returns only 27 rows.
Is that normal performance.
I was comparing query execution time against Vertica on single node database and when executing aggregate functions against entire database, Infobright is much faster. But when using WHERE or COUNT GROUP BY CALL_CONNECT_DATE, Vertica is much faster. As example COUNT GROUPED BY CALL CONNECT DATE or WHERE [CALL CONNECT DATE] =DATE in Vertica will take only about 15 seconds comparing to 200 - 300 second in Infobright.
I’m using community addition to evaluate Infobright performance.