[ Follow Ups ] [ Post Followup ] [ CPU-Central Message Board ] [ Home ]

Subject: Naw..
Name: SickOfItAll
Date: 7/10/2002 4:41:07 PM (GMT-7)
IP Address:
In Reply to: Re: rogue speculation posted by Sledge

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.

[ View FollowUps | Post Followup | E-Mail Sender | Main ]

[No follow-ups for this posting]

Post a Followup




Optional Link URL:
Link Title:
Optional Image URL:
Upload some images for this post

[ Follow Ups ] [ Post Followup ] [ CPU-Central Message Board ]