Marko, All
I did a simple test (C++ Builder):
start = TDateTime::CurrentDateTime();
DataSet->Open();
while( !DataSet->Eof)
{
for( int i =0; i<DataSet->Fields->Count; i++)
switch( DataSet->Fields->Fields[i]->DataType ){
ftString :
ftSmallint :
ftInteger :
ftWord ;
ftBoolean :
ftFloat :
ftCurrency:
ftBCD :
ftDate:
ftTime:
ftDateTime :
ftBytes :
ftAutoInc :
ftMemo :
ftFmtMemo :
ftFixedChar :
ftWideString :
ftLargeint :
ftVariant :
temp=DataSet->Fields->Fields[ i]->AsString; // test
}
DataSet->Next();
}
finish = TDateTime::CurrentDateTime();
The same query shows (in seconds)
BDE, Oracle Links 109 - 115
DOA 111 - 115
ADO (MS OLE DB for Oracle) 108 - 112
The speed seems to be the same, even ADO a little bit faster, although I thought that DOA should be fastest.
Any comments?