Re: Performance issue with oraoledb & Tadocommand


U¿ytkownik "pilmart" <martin.scullion@xxxxxxxxxxxxx> napisa³ w wiadomo¶ci
news:462dc3dd$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Hi There

Am currently using D5 & ado to insert large volumes of data into
an Oracle 10g db.

I'm using a connection string based on an OraOLEDB.Oracle oledb based
connection and a parameterised TADOCommand to insert the data, each call
to the insert requires 35 param values to be updated.

My process is simple delete the record (based on PK) again using
parameterised TADOCommand with PK as the param, on completion insert the
new record.

Sounds easy...but the performance is horrible, 8000 recs takes about
15mins, is this realistic or am I doing something blindly dumb.

I have not attempted to tune anything as yet some eveything is pretty much
default.

Any help appreciated.

do you realy need params when you insert data?

Karol Bieniaszewski


.

Relevant Pages

  • Performance issue
    ... I'm using a connection string based on an OraOLEDB.Oracle oledb based ... connection and a parameterised TADOCommand to insert the data, ... to the insert requires 35 param values to be updated. ... Not quite sure what you mean, I have a TADOCommand with parameterised sql in the commandtext propert therefore I have to provide parameters to go into the SQL. ...
    (borland.public.delphi.database.ado)
  • Performance issue with oraoledb & Tadocommand
    ... I'm using a connection string based on an OraOLEDB.Oracle oledb based connection and a parameterised TADOCommand to insert the data, each call to the insert requires 35 param values to be updated. ...
    (borland.public.delphi.database.ado)
  • ODBC & OLEDB
    ... The codes works fine with OLEDB to connect and run queries but with ODBC it ... What is wrong with the ODBC connection string? ... Security Info=False ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Invoking ADO.NET Connection String dialog?
    ... The data link dialog is an OLEDB feature. ... If you only use the OleDb managed provider in ado.net, ... > How do you invoke the connection string builder (Data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Invoking ADO.NET Connection String dialog?
    ... newsgroup to check for Sql Server in the return Connection String, ... > The data link dialog is an OLEDB feature. ... If you only use the OleDb managed provider in ado.net, ... > Program Manager - ADO.NET Team ...
    (microsoft.public.dotnet.framework.adonet)