Re: Data access perfomance

Eduardo Fonseca B. (EduardoFonsecaB@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> I've developed an application that loads xml files into
> Databases and I fell like I've perfomance problems inserting into the DB.
> I've test the application with just the xml file read, and the application
> runs really fast,
> but if i enable the insert into the db it look like it runs too slow.
> I insert the data after I've finished reading the xml file.
> I'm testing with a file that has 45613 registries, and the lenght of the
> procces is about 26 minutes.
> Can someone help me, is it normal, is the application running too slow?

So what databases do you have? Oracle, Access, MySQL, SQL Server?

How are you inserting the data? Do you send the XML documenent to
the back-end, do you produce INSERT statements or what do you do?

I'm sorry, but your question is too unspecific to be able to give a
good answer to.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

.

Relevant Pages

  • Re: Data access perfomance
    ... Sorry, I'm using Sql Server and Oracle 9i, on both databases the process is ... >> Databases and I fell like I've perfomance problems inserting into the DB. ... >> I insert the data after I've finished reading the xml file. ...
    (microsoft.public.data.oledb)
  • Re: Help getting started
    ... Free to use are the MS databases MS Access (not the office application only ... I would not start with that, standard are more than enough controls. ... methods however an XML file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Ini File vs Registry
    ... impossible to "incrementally" update an XML file. ... For component A of your app to reliably update its ... I'd rather see an abstract Registry API with application ... In the past, I did this, but Microsoft has made databases ...
    (microsoft.public.vc.mfc)
  • Re: Too match text I think.
    ... |> xml file on the server instead of using a database. ... it doesn't create or help manage databases. ... internet, then you can use your own computer as a web server, allowing you ... I too am new to php. ...
    (alt.php)
  • Re: Too match text I think.
    ... you can store your languages in a regluar file ... |> xml file on the server instead of using a database. ... it doesn't create or help manage databases. ... internet, then you can use your own computer as a web server, allowing you ...
    (alt.php)
Loading