Thanks you for the clarification, Mike. Best regards,
Pierre On Wednesday, April 5, 2017, Mike <[email protected]> wrote: > 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 <[email protected] > <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? > > 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 <[email protected] > <javascript:;>> 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 < > > > [email protected] <javascript:;>> 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 < > [email protected] <javascript:;>> > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/
