I tried following code:Open
If you don't need to edit the dataset, you can set its ReadOnly property to increase its opening speed. In that case, an additional information, required for INSERT, UPDATE, and DELETE statement generation, will not be requested.
Code: Select all
for i := 1 to 100 do begin qtest.Open; while not qtest.Eof do begin qtest.next; end; qtest.close; end;
time with readonly = true: 2,5 s
same code as above, following times:When UniDirectional is True, an application requires less memory and performance is improved.
unidirectional = false: 1,68 s
unidirectional = true: 1,79 s
i have everything tried many times, the times were slightly different, but the time difference was always there.
Do you have an explanation of these times? I really don't understand why your increase performance tips don't work, but it is really so.