Querying Oracle - Passthrough Query vs VBA using Data Connection 1

[kjv1611]

Can anyone tell me which would generally perform better? A passthrough query to an Oracle database or running the same SQL through a data connection via VBA?

I'd like to see if I can improve on performance using VBA over the passthrough query.

Or is it not so simple as "VBA > Passthrough" or "Passthrough > VBA"?

Thanks for any thoughts, suggestions, references, etc.

 

[PHV]

For me, passthru SQL is always better than any VBA code using the same SQL code ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kjv1611]

Thanks.

I was thinking the passthrough query would be simpler anyway, so if it works the same or better, I'd imagine would be best to stick with it.