Re: [Phpgroupware-developers] Intermodule record link system

[Chris Weiss]

right, but in an App, you only have the app name via code, and have to do a char
lookup to do the ID anyway.  And if indexes are made on the char fields there is
very little performance difference even in a very large db.  THe app name 
change is
a valid point, though I would hope this wouldn't occur often in the core apps, 
and
would be handled buy the setup app when needed.   if an admin wants to change 
the
name of an app in mid stream, they should be ready to deal with the 
consequences.

Darryl VanDorp (address@hidden) wrote*:
>
>Typically this is a performance issue. Most databases deal better
>with integers vs. varchar or char types.
>
>Also, i could envision an app-name change which would break the relational
>relationship.....
>
>-D
>>
>>
>> Here is my suggestion ...
>>
>> Just use the app name itself for the field value (defined as a
>> varchar(50) type). It should would just as well, would make the table
>> structure more readable, and wouldn't require calls to a core function
>> to translate application names to get application id numbers
>>
>>
>>
>> _______________________________________________
>> Phpgroupware-developers mailing list
>> address@hidden
>> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>
>
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>