If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appned Query Performance
I have an Append query with approx 25000 records with 8 fields and I am
trying to append it into a static table and the performance is abysmal. Can anyone suggest a way in which I can improve the performance? Is there a SQL Command that might be quicker and if so, can you provide a sample of the syntax? Many thanks in advance. Regards, Walt |
#2
|
|||
|
|||
Appned Query Performance
On Wed, 5 May 2010 10:26:05 -0700, Walt Herman
wrote: I have an Append query with approx 25000 records with 8 fields and I am trying to append it into a static table and the performance is abysmal. Can anyone suggest a way in which I can improve the performance? Is there a SQL Command that might be quicker and if so, can you provide a sample of the syntax? Many thanks in advance. Could you post the SQL? Where is the data coming from, and where is it going to? What indexes do you have? (Indexes on the source table should speed things up; indexes on the target table will slow things down, since Access must update them for every row). -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Appned Query Performance
"the performance is abysmal."
Can you quantify that in the number of second, minutes, or (shudder!!) hours that it takes? Do you have Set Warnings turned off in code or a macro before running the query? That can speed things up, but just don't forget to turn Set Warnings back on afterwards. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Walt Herman" wrote: I have an Append query with approx 25000 records with 8 fields and I am trying to append it into a static table and the performance is abysmal. Can anyone suggest a way in which I can improve the performance? Is there a SQL Command that might be quicker and if so, can you provide a sample of the syntax? Many thanks in advance. Regards, Walt |
Thread Tools | |
Display Modes | |
|
|