Subject: Naw..
Name:
SickOfItAll Date: 7/10/2002 4:41:07 PM (GMT-7)
IP Address: 66.241.70.2 In Reply to: Re: rogue speculation posted by
Sledge Message:
Close, but not really. Small ints roll at ~32k, the other 32k is reserved for negative ints. In Access (which I believe is the db behind this board) AutoNumbers default to long, and there is no way to drop it to small int.
My first suspicion would be an inefficient recursive thread crawling function (However there is no such thing as efficient recursion in ASP, it just can't handle it), and second would be an Access db backend slowing down due to poor indexing or a long time without compacting.
Personally, I have had to rewrite several recursive nesting functions that in theory should have worked beautifully, but in practice caused the server to drop to it's knees. Memory allocation goes completely off the deep end when recursion is involved, and is not freed correctly upon resolution. It's actually faster (albeit less pleasing to read the code) to just requery the database at each level in a tree. With ASP, some things you have to learn the hard way.
|