Posted by maxzsim via SQLMonster.com on 11/23/05 05:58

Hi,

I am using MS Access as the front end and it's using ODBC link to connect
to the backend tables residing at SQL SERVER.

I have some queries that are doing some calculation and the time taken to
retrieve the data has been quite slow.

The no of data in that table is around 500K records. and the tables have
already got the PKs defined.

How can i improve the performance of the query besides converting to SQL
Views or SP(this is going to be diffcult as i am getting some filter
parameters from the forms in MS Access) ?

Or what further checks shld i be doing to find out the cause. I have done
Performance Monitor and the CPU processing% is around 20 - 55% while running
those queries

kindly advise

tks & rdgs

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200511/1

[Back to original message]