You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2009/06/10 14:56:25 UTC
Posgres conf
Hi devs,
Should we not put "result-fetch-size="50"" as default and slightly change the comment for older versions ?
Jacques
Re: Posgres conf
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
+1 for this change.
IMO only few of the guys are using 7.5 and the proportion will be around 5
out of 50.
I had read information on the postgres website to use Postgres 8.x versions.
They are promoting it and keeping it as the lot stable release from all the
predecessor ones.
--
Ashish
On Thu, Jun 11, 2009 at 7:46 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Hi Divesh,
>
> I did not dig this subject profoundly. I only saw this comment in
> entityengine.xml
> <!-- use this attribute to make the EntityListIterator more effective for
> pgjdbc 7.5devel and later:
> result-fetch-size="50"
> -->
>
> And, as I guess, less and less people use postgres versions before 7.5 I
> suggested this change, that's all
>
> Jacques
>
>
Re: Posgres conf
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Divesh,
I did not dig this subject profoundly. I only saw this comment in entityengine.xml
<!-- use this attribute to make the EntityListIterator more effective for pgjdbc 7.5devel and later:
result-fetch-size="50"
-->
And, as I guess, less and less people use postgres versions before 7.5 I suggested this change, that's all
Jacques
From: "Divesh Dutta" <di...@hotwaxmedia.com>
> Hi Jacques,
>
> Is there any reason for setting default fetch-size = 50, because
> application is using queries by iterator and that can be benefited from
> fetch size=10 also. I don't know much about this. It would be great if
> you share this with me.
>
> Thanks
> --
> Divesh
>
>
> Jacques Le Roux wrote:
>> Hi devs,
>>
>> Should we not put "result-fetch-size="50"" as default and slightly
>> change the comment for older versions ?
>>
>> Jacques
>>
>
Re: Posgres conf
Posted by Divesh Dutta <di...@hotwaxmedia.com>.
Hi Jacques,
Is there any reason for setting default fetch-size = 50, because
application is using queries by iterator and that can be benefited from
fetch size=10 also. I don't know much about this. It would be great if
you share this with me.
Thanks
--
Divesh
Jacques Le Roux wrote:
> Hi devs,
>
> Should we not put "result-fetch-size="50"" as default and slightly
> change the comment for older versions ?
>
> Jacques
>
Re: Posgres conf
Posted by Jacques Le Roux <ja...@les7arts.com>.
Yes, to be clear it's about entityengine.xml, sorry.
Jacques
From: "Ashish Vijaywargiya" <vi...@gmail.com>
> Is it right subject for this email?
> Confused what you are referring Jacuqes.
>
> --
> Ashish
>
> On Wed, Jun 10, 2009 at 6:26 PM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
>> Hi devs,
>>
>> Should we not put "result-fetch-size="50"" as default and slightly change
>> the comment for older versions ?
>>
>> Jacques
>>
>>
>
Re: Posgres conf
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
Is it right subject for this email?
Confused what you are referring Jacuqes.
--
Ashish
On Wed, Jun 10, 2009 at 6:26 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Hi devs,
>
> Should we not put "result-fetch-size="50"" as default and slightly change
> the comment for older versions ?
>
> Jacques
>
>