Re: Data access perfomance

Sorry, I'm using Sql Server and Oracle 9i, on both databases the process is
too slow, I create the query and add the parameter to the OledbCommand, I
send just the column name and the value to an array,
then i create the insert from this array.

"Erland Sommarskog" wrote:

> 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: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: database dilemma
    ... > Dot net uses SQL Server and Oracle (check the help for the supported ... > versions) most efficiently as it has native drivers for these databases ... > Other databases use ODBC which work but with an overhead. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: database dilemma
    ... Dot net uses SQL Server and Oracle (check the help for the supported ... Other databases use ODBC which work but with an overhead. ... boss last week dropped vb.net on my desk and wants to create a web app and a ...
    (microsoft.public.dotnet.languages.vb)
  • MS SQL server Meata data question
    ... I have sql server 2000 up and running and using the provided ... browsing tools poked around and found that the databases in the system were ... the native php support for sql server doesn't have meta data functions like ... I need to do this for Oracle too but I think the native support for Oracle ...
    (comp.lang.php)
  • Re: Data access perfomance
    ... > 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. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)