Stephen the Cook <> wrote: > Man-wai CHANG <> wrote: >> It's really a pig in both speed an size... is there trick to speed >> it up? >> >> (what the hell is it+.Net doing in the background??) > > What is slow?
I have found that heavy batch operations that would generate 40,000 transactions a run would run faster in 2005 then 2000. That would be a batch process that took 3 hours to run went down to 2.25 running the same .net code base just a different sever instance for 2005 instead of 2000. (Same machine) Granularity became much better so your security is much tighter. Encryption of a column is real cool also. So what wasn't running fast anyway? Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.16.7/619 - Release Date: 1/7/2007 6:29 PM _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

