Many to many relation. How?

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Dec 7 09:49:20 CST 2004


On 12/7/04 6:20 AM, "Robert Brenstein" <rjb at rz.uni-potsdam.de> wrote:

>> 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.

That is right.

Also note that TIMESTAMP can be made as ULONG or ULLONG (8 byte) integer
value in the format

    YYYYMMDD  HHMMSS


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------




More information about the Valentina mailing list