Re: ADOQuery and Blob slowness
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 10/27/04
- Next message: Brian Bushay TeamB: "Re: Error: Could not convert variant of type (Null) into type (String)"
- Previous message: Brian Bushay TeamB: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- In reply to: Scott Elgram: "ADOQuery and Blob slowness"
- Next in thread: Scott Elgram: "Re: ADOQuery and Blob slowness"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 27 Oct 2004 16:13:31 -0500
> The project is a rewrite of a VB program and in VB this process seems to
>go a lot faster. Can anyone tell me why this seems to go so much slower and
>does anyone know a faster way to insert this data?
You have a fair amount of overhead just opening the dataset. The fastest way to
do this would be to use a TadoCommand component and an Insert Query.
If you still want to open the dataset just to insert new data use
DisableControls before opening the dataset
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: Error: Could not convert variant of type (Null) into type (String)"
- Previous message: Brian Bushay TeamB: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- In reply to: Scott Elgram: "ADOQuery and Blob slowness"
- Next in thread: Scott Elgram: "Re: ADOQuery and Blob slowness"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
