SQL Passthru

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Can I get confirmation that an SQL Passthru query will
bypass the jet engine.
I'm having performance issues and I think it is because
the query in question combines a passthru (to oracle)
and an access query and the jet engine bogs everthing
down. If I can bypass the jet engine by having absolutely
everything in a passthru I should be OK.
Sound correct??

I'm using Access 97 as FE and Oracle 8 as BE.
 
Pass-Through Queries are processed by the Server specified by the Connection
String, not JET.
 
Yes but with mixed results.
If the theory is correct, it is fine-tuning of the SQL
code that is needed and not due to the jet engine.
Thanks for the help.
 
Back
Top