HighTechTalks DotNet Forums  

XML or Access as DB, which is faster?

Dotnet Data Tools microsoft.public.dotnet.datatools


Discuss XML or Access as DB, which is faster? in the Dotnet Data Tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
VMI
 
Posts: n/a

Default XML or Access as DB, which is faster? - 01-05-2005 , 10:19 AM






I recently read that, with proper programming, you can use XML as a
database. Since I'm having problems retrieving data from an 300K-record
Access table (filling dataset with this query takes over 1 min. 30 secs. -
"select top 20 * from audit where Line > 0 order by Line asc" and Line is
primary key), I was wondering if XML would be any faster.

Thanks.



Reply With Quote
  #2  
Old   
Miha Markic [MVP C#]
 
Posts: n/a

Default Re: XML or Access as DB, which is faster? - 01-06-2005 , 07:04 AM






Hi,

I think you might have some problem with Access.
Anyway, XML is not meant to be a database although you might simulate some
very rudimentary database functionality with XML.
So, I guess you better find where your problem is with Access...

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"VMI" <vonchi_m (AT) yahoo (DOT) com> wrote

Quote:
I recently read that, with proper programming, you can use XML as a
database. Since I'm having problems retrieving data from an 300K-record
Access table (filling dataset with this query takes over 1 min. 30 secs. -
"select top 20 * from audit where Line > 0 order by Line asc" and Line is
primary key), I was wondering if XML would be any faster.

Thanks.




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.