Re: Is there an XMLDataAdapter?

BTW, here's an example of an XML database file that we use that has
typically about 15 applications writing to it. For any record that's
written, another application may find it and write/change the values. This
includes adding new files, deleting them and changing them. It's done
entirely with one file and there are currently about 25,000 records in it.
We actually use this for a bunch of services and apps so that the errors
aren't dependent on a db. However this is shared among them and when an
Message is processed and corrected, the node is found and update or deleted.
So in every sense this works just like you would with a rdbms system. While
performance can be a little sluggish at times, it's pretty quick and it's
been running for a good 5 months now without any noteworthy problem. The
main point worth nothing though is that application a may go find something
written out by application c (fileWatcher) and change the values that C
wrote. So even though it's one file, the only time we overwrite things is
when we specifically want to. All this btw is done with System.Xml and
System.Xml.XPath - then we periodically create reports on it using Xslt
(definitely a lot easier and more fun than the old vb6 days manipulating
dom)

<Exceptions position='4'>
<MessageID>1999232</MessageID>
<Message>An error occurred while parsing EntityName. Line 38, position
3.</Message>
<Job_x0020_Number>\\aug-filesrv1\Transcription\Signed\WS_EG_10013.xml</Job_1999232_Number>
<Exception>9/22/2005 10:33:08 AM</Exception>
</Exceptions>
<Exceptions position='10002'>
<MessageID>1896232</MessageID>
<Message>An error occurred while parsing EntityName. Line 32, position
3.</Message>
<Job_x0020_Number>\\aug-filesrv1\Transcription\Signed\WS_EG_10017.xml</Job_1896232_Number>
<Exception>10/18/2005 12:34:26 PM</Exception>
</Exceptions>
<Exceptions position='67'>
<MessageID>2009174</MessageID>
<Message>An error occurred while parsing EntityName. Line 40, position
3.</Message>
<Job_x0020_Number>\\aug-filesrv1\Transcription\Signed\WS_EG_10056.xml</Job_2009174_Number>
<Exception>9/21/2005 10:28:11 PM</Exception>
</Exceptions>
<Exceptions>
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:%23Tp0xCk2FHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> Bill,
>
> Maybe, my most important point is however that it is not to do in a real
> multiuser environment with *one* XML file.
>
> If you use many xmlfiles, what is a method that is not impossible and
> which I once in past have adviced (structured document processing with as
> goal to use the data of that). Than your solution is in my opinon one of
> the better ones because you are not sticked to the in fact simple format
> of the dataset.
>
> Using *one* XML file in a multiuser environment makes it needed that if
> one user needs to use that file, the other one has to wait until the first
> one is ready. (Complete file lock).
>
> That makes it in my opinion in a real multiuser environment impossible (or
> it should be something used or updated once a month) or would be a file
> for by instance sinle use on a pda, that will be processed afterwards.
> (Thinking about that is that probably where you are referencing too).
>
> Cor
>


.

Relevant Pages

  • Re: Comment C++ code like C#
    ... C#. BTW you can add a macro button to call doxygen automatically. ... Or doxycomment can probably be given a template for creating the xml format ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Smtp ohne Autentifizierung
    ... Einstellungen per XML verarbeitet. ... und aktualisier das Objekt dann von Zeit zu Zeit (bspw. ... der XML Datei) ... BTW: Das hätte man sinnvollerweise in einem neuen Thread behandelt. ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Re: How do you Implement a search box
    ... Content of XML?! ... the key factor is the hashing of items which can be seach. ... BTW, look on the microsoft.public.inetserver.indexserver, you can use it to index your files to search ... p> The data in my site will most likely be kept in XML files on disk. ...
    (microsoft.public.dotnet.framework)
  • Re: Why are todays apps sluggish?
    ... BTW, an XML for storing some user settings is not that bad, and fast enough. ...
    (borland.public.delphi.non-technical)
  • Re: Code review comment: "Noone uses tokens anymore"
    ... > BTW, the configuration file is pretty simple. ... why he'd suggest XML for a configuration file. ... overly complex - for the person who has to modify the config ...
    (comp.programming)