>>>Are there any guidelines for using array rather than a cursor? I have found that I prefer using cursors because of the ease of watching my data during development. Are there certain times were using an array is more beneficial?
>>
>>Yes of course there are places where arrays are more beneficial. ie:
>...
>>Arrays are faster then cursors (not always, depends on what you do).
>
>Cetin
>
>There were times in the past where I assumed arrays were faster, what with their being in memory and all, but I later found them to be slowing down my app. and, using cursors instead, I improved the speed manifold.
>
>Terry
Terry,
"(not always, depends on what you do)" was intentional:) In a few tests I can demonstrate they're faster and just demonstrate the reverse with another test - and yet another test to show they both are slower then lowlevel:)
Cetin