XML vs. Database Call

Results 1 to 3 of 3

Thread: XML vs. Database Call

  1. #1
    Join Date
    Dec 1969

    Default XML vs. Database Call

    Generally speaking, which method is faster?<BR><BR>I want to populate a typical &#060;asp:DropDownList&#062; with existing values. Should I populate the drop down from a direct database query or from a static, server-side XML file.<BR><BR>The XML file would be just as update to date.<BR><BR>Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default Database is MUCH faster <nm>


  3. #3
    Join Date
    Dec 1969

    Default RE: XML vs. Database Call

    In general the database might be quicker. It really depends on a lot of factors such as the amount of data and how fast a connection to the database is. I&#039;ve done it both ways without a noticable difference in speed.<BR><BR>That said, might I recommend caching the data in server memory regardless of whether it comes from the database or an XML file; that will give you the fastest response and if you throw it in cache then all sessions will have access to it.<BR><BR>Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts