Sep 19, 2006 How fast is NCOCI8 ? Lets compare 4 product and see, that NCOCI8 is one of the fastest Delphi data access components for Oracle.
In the test I have used: Each test consist of 1000 executions of the small program, in which one was gauged and summed the execution time of one of methods. The time is a summed time in seconds, that takes execution of 1000 times of this method. As timer I have used Win32 API - QueryPerformanceCounter. Also testing environment: - Server and workstation is the same machine;
- It is PII 266, 128Mb;
- Oracle8 server v 8.0.4;
- Oracle8 client v 8.0.4.
| Method | BDE | NCOCI8 | DOA | ODAC | | Append | 0,062 | 0,030 | 0,028 | 0,055 | | Cancel | 0,033 | 0,041 | 0,053 | 0,046 | | Delete | 7,888 | 7,242 | 4,105 | <Error> | | Edit | 0,018 | 0,029 | 0,007 | 0,045 | | First | 0,023 | 0,008 | 0,008 | 0,013 | | GetData | 0,006 | 0,010 | 0,010 | 0,010 | | Insert | 0,018 | 0,025 | 0,013 | 0,037 | | Last (1) | 0,022 | 0,008 | 0,022 | 0,020 | | Next (1) | 0,006 | 0,008 | 0,008 | 0,009 | | Open | 6,002 | 2,171 | 2,244 | 9,301 | | Post (2) | 7,392 | 5,608 | 8,347 | 8,388 | | Prior | 0,050 | 0,008 | 0,008 | 0,010 | | Refresh | <Error> | 1,650 | 1,197 | 2,354 | | SetData | 0,064 | 0,013 | 0,010 | 0,013 | | Fetch All (3) | 211,555 | 28,416 | 56,346 | 23,137 |
(1) Calls does not fetch anything. To see how fast is fetching, take a look on FetchAll.
(2) Post after data set editing.
(3) 10 times fetch all 55000 records from single table. :))) But ... If You have record set allready fetched on client, and now You need walk through records set, then use BDE. Good work Borland !! |
