Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Subject: Re: Default key size
To: user@ofbiz.apache.org
References: 
	<CADPkm85GHG37CUbomD32ECxnKFQLm+o8cZV-FOP-3eQM9rE30w@mail.gmail.com>
	<CANEMTSKsGWmdRYaQJ-=mA-g3P4GOOi7KUyWfS2FxEHqkNasFWw@mail.gmail.com>
From: Jacques Le Roux <jacques.le.roux@les7arts.com>
Organization: Les Arts Informatiques
Message-ID: <86535507-a24e-5039-1c30-861890ffb6ed@les7arts.com>
Date: Wed, 5 Apr 2017 21:42:03 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101
	Thunderbird/45.8.0
MIME-Version: 1.0
In-Reply-To: 
	<CANEMTSKsGWmdRYaQJ-=mA-g3P4GOOi7KUyWfS2FxEHqkNasFWw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
archived-at: Wed, 05 Apr 2017 19:41:47 -0000

For history sake: I committed localpostnew.

After a discussion (on dev ML or somewhere else? Unfortunately I can't find) it was commonly agreed that we should merge localpostnew in localpostgres 
and then remove localpostnew.

Later we commonly decided http://markmail.org/message/op2yl3pcbj3lgxpg to revert some changes in the new (merged) localpostgres

Feel free to use localpostnew. We could even put it back in, as suggested Nicolas, but I believe it should be then named otherwise to avoid confusion

Jacques


Le 05/04/2017 à 19:32, Mike a écrit :
> Pierre, here is an example from the demo data:
>
> accounting_OrganizationData.xml:    <PartyRole partyId="RECEIVING"
> roleTypeId="INTERNAL_ORGANIZATIO"/>
>
> The default of ID (20 chrs) is so small that you can't even properly spell
> "INTERNAL_ORGANIZATION"... I work with databases every day, and I would be
> so limited if I had to work with such small primary IDs.
>
> The thing is you don't want to not limit 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 from
> trunk for some reason.. It has unlimited primary ID sizes (ok, 2.1G), which
> allows me to create any sort of primary key I want.
>
>      <field-type-def type="id"         sql-type="TEXT" java-type="String"/>
>      <field-type-def type="id-long"  sql-type="TEXT" java-type="String"/>
>      <field-type-def type="id-vlong" sql-type="TEXT" java-type="String"/>
>
> If you think that type=TEXT is slow or less efficient..  Here is what
> postgres says about type "TEXT"..
>
> https://www.postgresql.org/docs/9.3/static/datatype-character.html
>
> *Tip:* There is no performance difference among these three types, apart
> from increased storage space when using the blank-padded type, and a few
> extra CPU cycles to check the length when storing into a length-constrained
> column. While character(n) has performance advantages in some other
> database systems, there is no such advantage inPostgreSQL; 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.
>
> On Wed, Apr 5, 2017 at 10:06 AM, Pierre Smits <pierre.smits@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 regards,
>>
>> Pierre Smits
>>
>> ORRTIZ.COM <http://www.orrtiz.com>
>> OFBiz based solutions & services
>>
>> OFBiz Extensions Marketplace
>> http://oem.ofbizci.net/oci-2/
>>
>> On Wed, Apr 5, 2017 at 5:10 PM, Mike <mz4wheeler@gmail.com> wrote:
>>
>>> Nice videos.  Regarding the mysql setup, you may want to include two
>> items:
>>> 1) Make sure mysql is setup as UTF8, discussed earlier in this mail
>> group.
>>> Requires tweaking:
>>>
>>> framework/entity/config/entityengine.xml
>>> /etc/mysql/my.cnf
>>>
>>> 2) Talk about adjusting the default sizes of primary keys (ID).  The
>>> default is an absurd 20 characters:
>>>
>>> framework/entity/fieldtype/fieldtypemysql.xml
>>>
>>>      <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/>
>>>      <field-type-def type="id-long" sql-type="VARCHAR(60)"
>>> java-type="String"/>
>>>      <field-type-def type="id-vlong" sql-type="VARCHAR(250)"
>>> java-type="String"/>
>>>
>>>
>>>
>>> On Wed, Apr 5, 2017 at 6:03 AM, Pranay Pandey <
>>> pranay.pandey@hotwaxsystems.com> wrote:
>>>
>>>> Thanks so much Deepak!
>>>>
>>>> Best regards,
>>>>
>>>> Pranay Pandey
>>>>
>>>>
>>>> On Wed, Apr 5, 2017 at 5:51 PM, Deepak Dixit
>> <deepak.dixit@hotwaxsystems.
>>>> com
>>>>> wrote:
>>>>> Hi Team,
>>>>>
>>>>> Here are some more videos from Pranay
>>>>>
>>>>> -  Setup OFBiz in IntelliJ IDEA IDE - Release 16.11 and Trunk
>>>>> <https://youtu.be/mxToh2rX7NY>
>>>>> - Setup OFBiz with MySQL <https://youtu.be/Lzmv0DCC5N4>
>>>>>
>>>>>
>>>>> Thanks Pranay for your effort.
>>>>>
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>>
>>>>> On Wed, Mar 22, 2017 at 7:07 PM, akash jain <akash1.jain1@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Nice videos, thanks Pranay!
>>>>>>
>>>>>> Thanks and Regards
>>>>>> --
>>>>>> Akash Jain
>>>>>>
>>>>>> On Thu, Mar 9, 2017 at 6:18 PM, Deepak Dixit
>>>> <deepak.dixit@hotwaxsystems.
>>>>>> com
>>>>>>> wrote:
>>>>>>> Hi Everyone,
>>>>>>>
>>>>>>> Pranay has created two video tutorials, these have been published
>>> on
>>>>> our
>>>>>>> OFBiz YouTube channel <https://www.youtube.com/user/ofbiz>:
>>>>>>> 1 - Apache OFBiz Mailing Lists <https://www.youtube.com/
>>>>>>> watch?v=bIS2kftvsq4>
>>>>>>> 2 - OFBiz Beginners Tutorial - Basic Setup Release16.11
>>>>>>> <https://youtu.be/efkB_aN-ODw>
>>>>>>>
>>>>>>> Thanks Pranay for these helpful videos.
>>>>>>>
>>>>>>> Thanks & Regards
>>>>>>> --
>>>>>>> Deepak Dixit
>>>>>>> www.hotwaxsystems.com
>>>>>>>