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.
