Re: Default key size

2017-04-07 Thread Jacopo Cappellato
:06 PM, Pierre Smits <pierre.sm...@gmail.com> wrote: > HI Mike, all, > > Re 2: Talk about adjustment of default key size > Why is that absurd? You believe it is too long/too short? > Following JIRA issue may be of interest: > https://issues.apache.org/jira/browse/OFB

Re: Default key size

2017-04-07 Thread Pierre Smits
gt;>> build >>>>>>> a >>>>>>> database. The jira is interesting, and GUIDs are a good example. >>>>>>> >>>>>>> Personally, I use postgresql, using the "localpostnew" type... >>>>>>&g

Re: Default key size

2017-04-06 Thread Paul Mandeltort
>>>>>> accounting_OrganizationData.xml:>>>>>> roleTypeId="INTERNAL_ORGANIZATIO"/> >>>>>>> >>>>>>> The default of ID (20 chrs) is so small that you can't even properly >>>>> spell >>>>

Re: Default key size

2017-04-06 Thread Mike
yourself when you first > >> build a > >>>>> database. The jira is interesting, and GUIDs are a good example. > >>>>> > >>>>> Personally, I use postgresql, using the "localpostnew" type... > Removed > >>>>> f

Re: Default key size

2017-04-06 Thread Michael Brohl
database. The jira is interesting, and GUIDs are a good example. >>>>>> >>>>>> Personally, I use postgresql, using the "localpostnew" type... Removed >>>>>> from >>>>>> trunk for some reason.. It has un

Re: Default key size

2017-04-06 Thread Paul Mandeltort
, >>>>> which >>>>> allows me to create any sort of primary key I want. >>>>> >>>>> >>>> java-type="String"/> >>>>> >> java-type="String"/> >>>>> >&g

Re: Default key size

2017-04-06 Thread Mike
>>>>> >>>> >>>> java-type="String"/> >>> >>>> >>>> >>>> java-type="String"/> >>> >>>> If you think that type=TEXT is slow or less efficient.. Here is what &

Re: Default key size

2017-04-06 Thread Jacques Le Roux
ree because of its additional storage costs. In most situations text or character varying should be used instead. Mysql has a similar type... I personally haven't tested it. On Wed, Apr 5, 2017 at 10:06 AM, Pierre Smits <pierre.sm...@gmail.com> wrote: HI Mike, all, Re 2: Talk about adjus

Re: Default key size

2017-04-06 Thread Jacques Le Roux
, 2017 at 10:06 AM, Pierre Smits <pierre.sm...@gmail.com wrote: HI Mike, all, Re 2: Talk about adjustment of default key size Why is that absurd? You believe it is too long/too short? Following JIRA issue may be of interest: https://issues.apache.org/jira/browse/OFBIZ-8343 Best regar

Re: Default key size

2017-04-05 Thread Mike
in fact >> character(n) is usually the slowest of the three because of its additional >> storage costs. In most situations text or character varying should be used >> instead. >> >> Mysql has a similar type... I personally haven't tested it. >> >>

Re: Default key size

2017-04-05 Thread Jacques Le Roux
e, all, Re 2: Talk about adjustment of default key size Why is that absurd? You believe it is too long/too short? Following JIRA issue may be of interest: https://issues.apache.org/jira/browse/OFBIZ-8343 Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions &am

Re: Default key size

2017-04-05 Thread Pierre Smits
, Apr 5, 2017 at 10:06 AM, Pierre Smits <pierre.sm...@gmail.com > <javascript:;>> > wrote: > > > HI Mike, all, > > > > Re 2: Talk about adjustment of default key size > > Why is that absurd? You believe it is too long/too short? > > Followin

Default key size

2017-04-05 Thread Pierre Smits
HI Mike, all, Re 2: Talk about adjustment of default key size Why is that absurd? You believe it is too long/too short? Following JIRA issue may be of interest: https://issues.apache.org/jira/browse/OFBIZ-8343 Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based sol