Yes, I will be posting it once I have finished the unit testing and load testing.

Thanks,

Fraggle

Just an update on this for everyone. Worked with a couple of the .NET guys in the office. Was able to take the entire process and move it...

Thanks for all of the assistance on this.

Fraggle

Well I am going to give it a try. I have about the same .NET skills as you do, but I work with some smart people who can help...

Gila,

There is absolutely no difference in duration after adding the new index. The one using parallism doesn't even use the new index. The execution plans are attached...

On a different tangent, as C#/VB is pretty darn fast for loops and such, any thoughts on potential performance gain/loss by doing the stuff in a CLR? By this...

Ok, so I understand the breadcrumbs now. However, I am not seeing how they will eventually get me the Left/Right node for the nested set? Or are you...

GSquared,

Not familiar with the "Bread Crumb" method. Any references on that one?

Thanks,

Fraggle

GSquared,

When you say "fall back and punt this" I assume you are referring to a refactoring of the code. Then yes.

However, here is the deal. We...

GSquared (12/28/2011)

---

Hate to say it, but this is the Internet, and I don't open files that could contain auto-executable code from unknown sources.

Can you either post the code in the...

I can and will...

Gila,

Sorry for not getting back with you sooner. For some reason I never saw an email. Still not sure what happened.

In answer to your question about the 'test'...

Gila,

Just wanted to follow up and see if you saw anything on those plans.

Thanks,

Fraggle

AWESOME Gila. Thanks. Fraggle

Gila, more than happy to help. I would be interested to know your thoughts on it. I am usually pretty good on this stuff (at least I...