By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Query runs quickly as Select, slowly as Append?

P: n/a
I've got a query that comes up with a dataset list in < 3 seconds when
run just in DataSheet mode...but the same query, when run as intended
(Append to an empty table) takes upwards of 30 minutes to run.

The target table is via an ODBC link to a temporary DB on the user's
C: drive.

The source tables are a mixture of Oracle, Sybase, and JET tables -
all via ODBC links. Each component of the query comes up very
quickly when run by itself AND all the components together come up
pretty quickly when run just in "Select" mode - it's only when the
query has to append it's output that it slows to a crawl.

I've never seen this before.

Anybody have any thoughts?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"PeteCresswell" <Go**********@FatBelly.com> wrote in message
news:74**************************@posting.google.c om...
I've got a query that comes up with a dataset list in < 3 seconds when
run just in DataSheet mode...but the same query, when run as intended
(Append to an empty table) takes upwards of 30 minutes to run.

The target table is via an ODBC link to a temporary DB on the user's
C: drive.

The source tables are a mixture of Oracle, Sybase, and JET tables -
all via ODBC links. Each component of the query comes up very
quickly when run by itself AND all the components together come up
pretty quickly when run just in "Select" mode - it's only when the
query has to append it's output that it slows to a crawl.

I've never seen this before.

Anybody have any thoughts?


The datasheet for a select query will pop up after only a few dozen rows
are retrieved whereas the append query has to process ALL of the rows.
What does the select query do if you open the datasheet and then do a
go-to-last?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.