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.
Re: XML or Access as DB, which is faster? - 01-06-2005 , 07:04 AM
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
"VMI" <vonchi_m (AT) yahoo (DOT) com> wrote
|Thread Tools||Search this Thread|