• 0

Which would be faster XML or Access DB


Question

OK I have this little application that keeps track of my DVD Library. It contains information about the DVD like title, sound/video formats, aspect ratio, and who might be borrowing it, etc.

It is currently stored in an XML file. But I am wondering if it would perform better on an acess database?

Anyone have any thoughts on this? Just remember it is done using C# on the .NET Compact framework.

8 answers to this question

Recommended Posts

  • 0

You know what, I can't even find a way to get to the Access Database. I saw a website link, but it was using a wrapper written in VB. Do you know of any articles demonstrating the use of Access or pocket Access on a pocketpc?

  • 0

Not sure how it goes on Pocket PC, but regularly you would use ODBC to connect.

Here's a quick example of how to connect (taken from the MSDN library).

public void CreateOdbcConnection() 
{
   string myConnString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\bin\nwind.mdb";
   OdbcConnection myConnection = new OdbcConnection(myConnString);
   myConnection.Open();
   //do stuff
   myConnection.Close();
}

  • 0

yeah, i already tried this. The problem is there is not an ODBC connection available. There is a SQLCE connection but not ODBC. I think I am just going to stick with the XML for now.

  • 0

Ah here is the statement from Microsoft:

Microsoft SQL Server 2000 Windows? CE Edition (SQL Server CE) is distributed as a downloadable development product for mobile applications. You can deploy SQL Server CE to an unlimited number of mobile devices provided that they operate in stand-alone mode. In stand-alone mode, the device does not connect to or use the resources of any SQL Server system not present on the device.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • #1 DP and #8 HDMI, you can connect both monitors to your motherboard. It's not just one or the other, you can use both at the same time.
    • So, I will see exactly ZERO ads, because I f**ked off the stupid Facebook/Meta ages ago. I don't miss any of it at all.
    • Thunderbird 139.0.1 by Razvan Serea Thunderbird is a free, open-source, cross-platform application for managing email and news feeds. It is a local (rather than a web-based) email application that is powerful yet easy-to-use. Thunderbird is clean and elegant by default, but easily customizable to match your workflow and visual preferences. It is loaded with unique and powerful features. Thunderbird is developed, tested, translated and supported by the folks at Mozilla Corporation and by a group of dedicated volunteers. Thunderbird gives you control and ownership over your email. There are lots of add-ons available for Thunderbird that enable you to extend and customize your email experience. Thunderbird gives you IMAP/POP support, a built-in RSS reader, support for HTML mail, powerful quick search, saved search folders, advanced message filtering, message grouping, labels, return receipts, smart address book LDAP address completion, import tools, and the ability to manage multiple e-mail and newsgroup accounts. Thunderbird 139.0.1 fixes: Thunderbird could crash when copying a local folder to IMAP Upgrade to 139.0 incorrectly switched Table View to Cards View Download: Thunderbird 139.0.1 for Windows (EN/US) | 32-bit | ~70.0 MB (Open Source) Download: Thunderbird 139.0.1 for Linux (EN/US) | 74.7 MB Download: Thunderbird 139.0.1 for Mac OS (EN/US) | 127.0 MB Download: Thunderbird 139.0.1 in other languages View: Thunderbird Website | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • It's both. Bazzite forked the game mode so it's not just simply running big picture mode like on full desktop.
  • Recent Achievements

    • First Post
      ClarkB earned a badge
      First Post
    • Week One Done
      Epaminombas earned a badge
      Week One Done
    • Week One Done
      Prestige Podiatry Care earned a badge
      Week One Done
    • Week One Done
      rollconults earned a badge
      Week One Done
    • Week One Done
      lilred1938 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      142
    2. 2
      Xenon
      130
    3. 3
      ATLien_0
      124
    4. 4
      +Edouard
      102
    5. 5
      snowy owl
      97
  • Tell a friend

    Love Neowin? Tell a friend!