Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is OO4O notoriously slow with VB4?
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
Hadi Kanan <Hadi_at_force12.com> wrote in article
<$he3wAAGumSzEwBp_at_force12.com>...
> We have recently converted a 16bit VB3 application accessing an Access 2
> database into a 32 bit VB4 application accessing an Oracle7 server. The
> 16 bit app used a number of snapshots to fill list boxes etc, but OO4O
> doesn't seem to support snapshots, only dynasets. The upshot of this is
> that list boxes now seem to take an age to fill (45 secs for 400 list
> items!) Creation of the dynaset seems to be fast enough so I don't
> think database optimisation will help. Is it just that OO4O is a slow
> way to do things?
>
> Any help would be greatly appreciated.
>
> TIA
>
> Hadi
> --
> Force12 Solutions Ltd
>
Received on Thu Apr 10 1997 - 00:00:00 CDT