-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 there was not statement on comparison, you are correct. have you done a test though to see what the real difference in msec is, on what you define as a large database.
Sven Wesley sent the following on 2/17/2009 11:28 AM: > Sorry guys, but I don't agree on the first point. An Integer or Number as > primary will always win the time race compared to a varchar, specially if > there's a group or order clause included. I do agree about the flexibility > (that also comes with other complexities), but the performance issue is > unfortunately not that simple. Of course, it's also a matter of how big your > database is. The bigger the worse. > > Regards, > Sven > > > 2009/2/17 Jacques Le Roux <[email protected]> > >> 2d or 3d time this question is asked : time for a FAQ >> >> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz >> >> Thanks David >> >> Jacques >> >> From: "David E Jones" <[email protected]> >> >> >>> 1. The performance overhead is minimal on modern database systems. >>> 2. Character strings give significant flexibility, especially when it is >>> common to migrate data from other systems that have >>> characters in their IDs. >>> 3. Being able to prefix IDs is used in a number of places in OFBiz, >>> including prefixes for entire systems when data transfers >>> between them are done to separate ID spaces. >>> >>> Welcome to the real world! ;) >>> >>> -David >>> >>> >>> On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: >>> >>> Hello Frns, >>>> I am a *newbie* in OFBiz and was playing with the OFBiz. >>>> >>>> During my play I found that in OFBiz data type for all the primary keys >>>> are VAR-CHAR, but VAR-CHAR data type is not a good practice for the >>>> efficiency perspective because it takes extra time during searching. Can >>>> anyone please tell me why OFBiz uses VAR-CHAR data type used for primary >>>> key >>>> instead of NUMERIC data type. >>>> >>>> Any help would be greatly appreciated. >>>> >>>> >>>> Dhruv. >>>> >>> >> > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmxQ6rP3NbaWWqE4RAkfjAKClPAs2o0o58AdYXTNWxsxK/+tAQgCePrLa Z7El/e8xhPwsbThwrEuo8zU= =58Or -----END PGP SIGNATURE-----
