Re: Is OO4O notoriously slow with VB4?

In article <01bc4589$2faffcb0$25d9bec2_at_ib>, Ilia Bashtanov <iliab_at_mmc.ru> writes
>I've tested Oracle Objects for OLE 2.00.07.2.0 with VB4 (32 bit).
>
>500-row, 7-col array filled from dynaset in 2 seconds.
> ^^^^^^^^^
>It is faster than OO4O 2.00.07 (16 bit) with VB3 (5 - 6 seconds)
>
>Have you read OO4O Help (Technical Notes -> Coding Techniques) ?
>I use ORADYN_READONLY + ORADYN_NOCACHE + ORADYN_NO_BLANKSTRIP
>dynaset creation parameters and technique from above help topic.
>
>Best regards
>~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Ilia Bashtanov
>iliab_at_mmc.ru
>phone +7 (095) 974 30 30
>fax +7 (095) 974 30 20
>~~~~~~~~~~~~~~~~~~~~~~~~~~~
>

Thanks Ilia

I've just tried what you suggested. With all three parameters in the createdynaset statement, only one record is returned even though a recordcount on the dynaset shows 500 records present. If I take out ORADYN_NOCACHE, all 500 records are loaded into the array, but it takes 58 seconds! Am I going insane or am I doing something wrong?

Hadi

-- 
Force12 Solutions Ltd