bungpeng Posted August 28, 2003 Posted August 28, 2003 I am still using VS.NET 2002 and I found that the DataSet is very slow (few times slower) compare with others when handling database records. Anyone face the same problem as me? Is it problem of .NET Framework 1.0? Does .NET Framework 1.1 solve this problem or still same? TQ Quote
Moderators Robby Posted August 28, 2003 Moderators Posted August 28, 2003 Mine works fine in 1.0 Quote Visit...Bassic Software
Diablicolic Posted August 29, 2003 Posted August 29, 2003 Why do you guys still use 1.0? Quote "Reality is fake, Dreams are for real"
Moderators Robby Posted August 29, 2003 Moderators Posted August 29, 2003 I'm just to busy too upgrade or install anything on my various partitions. If I upgrade one I need to do all of them. Quote Visit...Bassic Software
bitburner Posted September 1, 2003 Posted September 1, 2003 I have used the Dataset in both 1.0 and 1.1 and can tell no difference in performance. Quote
bungpeng Posted September 2, 2003 Author Posted September 2, 2003 Don't you feel that use DataSet is quite slow? Quote
bitburner Posted September 2, 2003 Posted September 2, 2003 No I don't think so. Slow compared to what? And what part of it is slow? All of it or just the part when you are loading data from a select query? If that is the case then I would recommend checking your select Query's performance. I have seen other data access tools work faster, but the dataset offers lot's of nice features that make it worth using (not to mention it hooks right into the rest of the managed code in .NET). If you are considering going back to disconnected recordsets in ADO 2.6 or 2.7 keep one thing in mind, that using an interop wrapper for this will not only hurt the performance of your application, it may even make it worse because your calls now have to pass through a Runtime Callable Wrapper (RCW). In order to make method calls to a COM interface. This is not a good solution by any means. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.