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