SMO Speed

Topics: Developer Forum
Nov 17, 2006 at 1:51 AM
First of all your timing is impecable, of course we are looking for something in this realm at this point in time!

First thing I noticed was how incredibly slow SMO was in iterating the tables and columns.

Something to look at:

Great work thus far, and I look forward to being able to contribute more as this progresses.

Shea Strickland
Nov 17, 2006 at 8:36 AM
Thanks, Shea. I looked at the enum objects stuff a little but didn't get it implemented yet. That makes sense. I'm running a dual 2.8 machine with 3GB RAM, so I'm not a good speed tester. Would you like to be added to the project?
Nov 19, 2006 at 11:49 PM
How could I refuse an offer like that =D

In terms of speed im using it on 400 odd tables so it's a noticable difference. Have there been any thoughts on batching updates etc to descrease the <notarealword>chaty-ness</notarealword> of the communications?

Thanks for the invite!