Many to many relation. How?

Robert Brenstein rjb at rz.uni-potsdam.de
Tue Dec 7 05:20:06 CST 2004


>>If you delete, then your ids are not serialized (as in newer not 
>>always having a higher number) but you probably timestamp them 
>>anyway. So if you do not have the requirement that they keep always 
>>increasing, then you can still use the built-in recId as id.
>>
>>Robert
>
>Hm, not bad. But won't a much longer string decrease speed of queries?
>The best solution would be an integer, wouldn't it? But then the 
>database could run out anytime.
>Or do you think of a relation based on more than 2 fields?
>
>
>Cheers,
>Ralf

RecId is an integer. So is (at least can be) the timestamp. I would 
not be concerned about the speed decrease related to having a tad 
longer query string. The network performance will remain the 
bottleneck IMHO.

Robert


More information about the Valentina mailing list