OraFAQ Forum: Programming Interfaces » MS Access query to Oracle table slower than query to MS SQL Server

Home » Open Source » Programming Interfaces » MS Access query to Oracle table slower than query to MS SQL Server (MS Access 2003 , Oracle 10G, MS SQL Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MS Access query to Oracle table slower than query to MS SQL Server [message #360992]

Mon, 24 November 2008 09:50

nutoom
Messages: 2
Registered: November 2008

Junior Member

I create MS access query (connect to oracle table) and compare performance with same MS access query with MS SQL table (same table size). Why performance of the first is slower thant the secend more than 5 times?

How can I tune performance between MS Access with Oracle table (MS access call Oracle table via ODBC and use table link at MS Access).

Please advice
Thank you in advance

Report message to a moderator

Re: MS Access query to Oracle table slower than query to MS SQL Server [message #360995 is a reply to message #360992]

Mon, 24 November 2008 10:14

Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Much more work:
1/ Network layer
2/ Conversion layer
...

Regards
Michel

Report message to a moderator

Re: MS Access query to Oracle table slower than query to MS SQL Server [message #361251 is a reply to message #360992]

Tue, 25 November 2008 09:38

nutoom
Messages: 2
Registered: November 2008

Junior Member

Dear Michel Cadot,

Please give more explaination.
Is it normal result or not for MS access - oracle (slower than Ms access with MS SQL server?

What is 2 layer for tuning?

Thank you very much

Report message to a moderator

Re: MS Access query to Oracle table slower than query to MS SQL Server [message #361268 is a reply to message #361251]

Tue, 25 November 2008 10:32

Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It can be slower/faster/same time it depends on so many things.
No general answer just specific on each case.

Regards
Michel

Report message to a moderator

Previous Topic:	How to give PHP argument to oracle select?
Next Topic:	Problem with ODT for .NET

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 19:52:54 CDT 2025