Dirk
User
Junior Boarder
| Posts: 16 |   |
Karma: 0
|
|
Speed compared to BDE
|
|
Posted: 2005/08/03 15:00 |
|
|
|
|
Hello Dmitry
I did some Speed comparism between BDE and Anydac on MSSQL
Its a simple Table with some FK relations, nothing special. Task is to insert in total about 26044 records out of memory
The Data is inserted in 3 loops, the technic is far from optimum but that's like it is.
A request life TQuery with a select * from EntityName where 0=1. The Query is prepared and the data is inserted with insert and post
for j:= 0 to FVerrechnungsTag.Betrieb[i].ArtikelCount -1 do
begin
try
qryBDETarget.Insert;
qryBDETargetID_DATUM.AsInteger:= FVerrechnungsTag.ID_Datum;
qryBDETargetID_BETRIEB.AsInteger:= FVerrechnungsTag.Betrieb[i].ID_Betrieb;
qryBDETargetID_ARTIKEL.Text:= FVerrechnungsTag.Betrieb[i].Artikel[j].ID_Artikel;
qryBDETargetBESTAND.AsInteger:=FVerrechnungsTag.Betrieb[i].Artikel[j].Bestand;
qryBDETarget.Post;
With BDE, I got this result
4448 Records written in 2859ms
8580 Records written in 5437ms
13016 Records written in 8187ms
After replacing the TQuery with a TADQuery I got these results.
4448 Records written in 8656ms
8580 Records written in 16750ms
13016 Records written in 25719ms
So what are the options I have to set to get more/full speed?
|
|
