[teiid-dev] "MaxResultRows" in the Connectors

[Ken Johnson]

+1

Charles Mosher wrote:
> +2
>
> ----- Original Message -----
> From: "John Doyle" <jdoyle at redhat.com>
> To: "Paul Nittel" <pnittel at redhat.com>
> Cc: teiid-dev at 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 at redhat.com> 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 at redhat.com>
>> To: teiid-dev at 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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/teiid-dev
>> _______________________________________________
>> teiid-dev mailing list
>> teiid-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/teiid-dev
>>     
> _______________________________________________
> teiid-dev mailing list
> teiid-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-dev
> _______________________________________________
> teiid-dev mailing list
> teiid-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-dev
>   


-- 
Ken Johnson
Sr. Product Manager
JBoss Middleware Business Unit
Red Hat, Inc
978.392.3917
ken.johnson at redhat.com