7 seconds on a simple select * command on a table(collection) containin 158 rows(documents).
Yes, the mongodb database I am querying into does have 268 collections. On Tue, Mar 1, 2016 at 11:13 AM, Jacques Nadeau <jacq...@dremio.com> wrote: > I haven't had a chance to look at the profile in detail yet. Do you see > consistent behavior on multiple queries? > > Does your mongodb happen to have a large number of collections and/or > databases? (Just guessing here). > > > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Sun, Feb 28, 2016 at 8:54 PM, Rifat Mahmud <rftm...@gmail.com> wrote: > > > Here is the json profile of the query: http://pastebin.com/tqang1Y0 > > Attached the screen shot of the query profile web view too. > > I am using everything in default configuration for apache-drill-1.5.0, > > just changed the MongoDB location from localhost to the remote IP in the > > storage configuration. > > > > On Sun, Feb 28, 2016 at 3:16 PM, Jacques Nadeau <jacq...@dremio.com> > > wrote: > > > >> Can you share what the profile looks like? Where is the time being > spent? > >> Unless something is really wrong (or these are gigabyte sized records), > >> I'm > >> guessing there is a configuration issue or bug you are hitting. > >> > >> > >> -- > >> Jacques Nadeau > >> CTO and Co-Founder, Dremio > >> > >> On Sun, Feb 28, 2016 at 12:04 AM, Rifat Mahmud <rftm...@gmail.com> > wrote: > >> > >> > I am running embedded drill on a single 8 core, 16 GB RAM machine. I > am > >> > performing a join query(select * from t1, t2 where t1.a = t2.b) on a > >> remote > >> > MongoDB database. The tables(collections) contain 2 and 4 > >> rows(documents) > >> > only. The query is taking 27 seconds. > >> > Can the query be made faster by using drill with Zookeeper cluster? > And > >> if > >> > the answer is yes, by how many factors? Please, elaborate about the > >> > real-timeliness of Apache Drill. > >> > > >> > > > > >
