do with it. For one thing the number 32 only needs 6 binary places to
represent it. ;^)
The "bit" function may be limited (as it concerns bit math) but not
something like recursion - for example on a 32 bit system I can recurse
down more than 32 levels in CF (or in C or in Java or in other database
systems). You often see numbers that relate to bit math and register
size in programs (2,4,8,16,32,64,128,256,etc) - but that's an indication
of binary math and register size.
In the case of the recursion of Stored Procedures in SQL 2000 it's just
a nice round figure. Small enough not to cause performance issues, but
large enough that it's rarely an implementation barrier.
Jim Davis
-----Original Message-----
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Sunday, September 28, 2003 3:41 PM
To: CF-Talk
Subject: Re:how many?
Just an FYI - it stops after 32 levels (actually, at 31 I believe) not
to stop runaway values but because it's a 32-bit system.
Same deal with the bit function in CF - limited by the system it is on.
Once 64-bit systems (OS/app/db) come along, I assume that it will
support up to 63 levels.
>For what it's worth I've gone several dozen deep (modeling a nested
tree
>hierarchy) and have hit no problems. There is no limit (beyond system
>resources) that I know of.
>
>In fact in my little experiment I was more limited by SQL server (which
>throws an exception after 32 levels of recursion to prevent runaway
>requests) than by CF.
>
>Jim Davis
>
>-----Original Message-----
>From: Ben Doom [mailto:[EMAIL PROTECTED]
>Sent: Sunday, September 28, 2003 12:46 AM
>To: CF-Talk
>Subject: Re: how many?
>
>As far as I know, there's no theoretical limitation on depth.
>
>I know I've gone 2 deep with no trouble, and think I might have gone 3
>deep.
>
>The best way to know for sure is to test it, of course. :-)
>
>--Ben Doom
>
>Ray Bujarski wrote:
>
>> How many structures deep can I nest?
>>
>> Is this possible?
>>
>> block["#cell_type#"]["#cell#"]["#getKey#"]
>>
>> Thanks,
>>
>> Ray
>>
>>
> _____
>
>[Todays
_____
[Todays
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
