Re: ODBC performance Vs. Oracle*Glue

>
>I'd like to hear more about this. Has Oracle set any dates yet?
>Are there any specifications?
>
>>I don't know if glue calls are part of it, but it should be an effective
>>workaround.
>
>If you can attach an oracle database to a VB data control that would
>be fantastic!
>
> -- Jim

I would like to see some test data comparing various ways to run SQL and various products. I bet you would find that submitting stored procedure calls to run queries using ODBC is pretty fast and at the top of the list. Any product that submits the SQL up to the server where it must compile optimize before running will not beat a precomplied optimized stored procedure. I realize that using stored procedures gets you into proprietary SQL but if you are running a transaction oriented app and need the speed who cares about standards the object is speed. I find the ease of using data objects in VB is a beautiful paradigm and is much more flexible than using a proprietary VBX Thx Dave L Received on Tue Oct 04 1994 - 08:04:45 CET