Performance with DataSet: suggestions for best practices?

From: Chris Zopers (test123test12_at_12move.nl)
Date: 03/25/05

  • Next message: Håkon Eide: "Performance question regarding the use of DataRelation in DataSet" 
    Date: Fri, 25 Mar 2005 01:47:39 -0800

    Hello,

    I've developed a lot of database-systems in Microsoft Access. Now I'm
    going to develop a large system in VB.NET. Before I start, I'm testing
    some performance differences between MS Access and VB.NET. When I
    connect to a large table (more than 100.000 records) from a database
    with MS Access, everthing works just fine and the performance is very
    good. When I load the same table in a DataSet in my VB.NET application,
    it takes a very long time to load that table.

    I'd like to know from experiences VB.NET programmers: what is the best
    way to work with data? DataSets are all in-memory, so won't that take a
    lot of the computers memory? And that's probably why the loading of a
    large table takes so long. Does anyone have suggestions?

    Greetings,
    Chris.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: Håkon Eide: "Performance question regarding the use of DataRelation in DataSet"