Re: Data transfer performance issue


"Dmitry Arefiev [da-soft.com]" <darefiev@xxxxxxxxxxx> wrote:
One change. Instead of
ADStoredProc1.Params[..].AsXxxx[i]
use
ADStoredProc1.Params[..].Values[i]

Regards,
Dmitry

--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access engine
ThinDAC - multitier data access engine


Sorry - Unable to use 3rd party s/ware so have to use some combination of ADO/PL/sql/Oracle.

Was thinking I could maybe pass my recordset to a PL/SQL Package and use bulk binds to load it to the database

Anyone had any experience with this ???
.

Relevant Pages

  • Re: mysql and dates
    ... ASA, DbExpress, ODBC freeware data access engine ... ThinDAC - multitier data access engine ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: mysql and dates
    ... ASA, DbExpress, ODBC freeware data access engine ... ThinDAC - multitier data access engine ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Alternative to dbclient.dll
    ... ASA, DbExpress, ODBC freeware data access engine ... ThinDAC - multitier data access engine ...
    (borland.public.delphi.non-technical)
  • Re: mysql and dates
    ... ASA, DbExpress, ODBC freeware data access engine ... ThinDAC - multitier data access engine ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: middleware for mysql
    ... ASA, DbExpress, ODBC freeware data access engine ... ThinDAC - multitier data access engine ...
    (borland.public.delphi.thirdpartytools.general)