Re: [teiid-dev] "MaxResultRows" in the Connectors

+2 ----- Original Message ----- From: "John Doyle" <jdoyle(a)redhat.com&gt; To: "Paul Nittel" <pnittel(a)redhat.com&gt; Cc: teiid-dev(a)lists.jboss.org Sent: Wednesday, March 17, 2010 11:50:44 AM GMT -05:00 US/Canada Eastern Subject: Re: [teiid-dev] "MaxResultRows" in the Connectors +1 ----- "Paul Nittel" <pnittel(a)redhat.com&gt; wrote: > Ramesh: > > I completely support the idea of eliminating the 10,000 MaxResultRows > default. It should default to "unlimited". (It's not like RDBMSes > constrain their users in such a fashion.) > > Cheers, > ------- > Paul Nittel > JBoss Sr. Quality Assurance Engineer > Red Hat, Inc. > 314-336-2907 (81-62907) > > Delivering value year after year. > Red Hat ranks #1 in value among software vendors. > http://www.redhat.com/promo/vendor/ > > > > ----- Original Message ----- > From: "Ramesh Reddy" <rareddy(a)redhat.com&gt; > To: teiid-dev(a)lists.jboss.org > Sent: Wednesday, March 17, 2010 10:32:00 AM GMT -06:00 US/Canada > Central > Subject: [teiid-dev] "MaxResultRows" in the Connectors > > Teiid supports a property called "MaxResultRows" in Connector > properties, which defaults to 10,000 rows. The expected behavior of > this > is to throw an exception when user queries more than 10,000 rows > through > this connector. > > However, this default behavior seems like a exceptional condition > than > normal behavior expected by user any time. This *was* designed more > for > the development time aid than the runtime. > > Here is an example of community user tripping over it. > http://community.jboss.org/message/532560#532560 > > I propose, we change the default value of this property to zero (0) > that > means the "MaxResultRows" will be set to "unlimited" in the default > scenario. If user requires to restrict max rows they can *explicitly* > set a value that they are comfortable with. > > Any objections? > > Thanks. > > Ramesh.. > > _______________________________________________ > teiid-dev mailing list > teiid-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/teiid-dev > _______________________________________________ > teiid-dev mailing list > teiid-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/teiid-dev _______________________________________________ teiid-dev mailing list teiid-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-dev _______________________________________________ teiid-dev mailing list teiid-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-dev