drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Keranen <m...@hybriddba.com>
Subject Re: Sql Server Query taking long time to run
Date Thu, 24 Nov 2016 22:49:59 GMT
How long do the same queries take to run directly on SQL Server?

> On Nov 24, 2016, at 1:15 PM, Sanjiv Kumar <sanjivktr@gmail.com> wrote:
> 
> Hello
>        I have sql server databases having 1 million of data. I am using
> drill in window having 1.8 version. And Its running in embedded mode.
> 
>          While firing select query, it will take almost 1 hour to run the
> query.
> 
> Even i have given limit also it will take 1 hour to run.
> 
> I am executing this query:-  select * from demoplugin.dbo.category limit 5;
> 
> ‚ÄčEven this query also take 1 hour to show output.
> Please tell some solution for that.‚Äč
> 
> -- 
> Thanks & Regards.
> Sanjiv Kumar.

Mime
View raw message