Query runs slow on SQL table

[Gkirkup]

I have a link to a table in an SQL database. When I run a query to append records to that SQL table, it runs very slowly. What would take a few seconds to update an Access accdb takes 20 minutes to run!
Is there anything I can do to correct this?

Robert

 

[CJ_London]

you are dealing with network and server performance so perhaps the sql table or your query is not optimised or the server is under specified

 

[Galaxiom]

If the data to insert is in a local table and the query has a join to the destination SQL table (eg an outer join with a Null condition to avoid duplicates) then it can be really slow.

Indexes can make a big difference to performance too. Are there appropriate indexes on the destination table?