AnsweredAssumed Answered

how to improve performance for RDBMS storage plugin

Question asked by sure on Oct 9, 2016
Latest reply on Dec 19, 2016 by maprcommunity

Hi,

 

I am curious to know the options to improve the performance of MySQL queries, does the storage plugin pushes down the queries to RDBMS

Background:

While exploring drill, i was testing out few scenarios and was impressed with the functionality to be able to join any data.

 

In one of my test i have executed an aggregate query via Drill (Storage plugin to mysql) and on Mysql DB, the fetch time is 5X more via storage plugin in Drill.

 

wanted to know how can the query execution time be reduced and which factors influence it.

 

Any help would be great.

 

Warm Regards,

Suresh

Outcomes