[AccessD] Access and TaskManager

Charlotte Foust cfoust at infostatsystems.com
Thu Apr 7 16:10:02 CDT 2005


I've seen this kind of bottleneck with ODBC links to SQL Server too.
Unless you use a passthrough query or structure your ADO to do the
processing on the server, you're stuck.

Charlotte Foust


-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com] 
Sent: Thursday, April 07, 2005 12:13 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access and TaskManager


Its to an Informix db.  I can check the access db...and the table is
being 
populated...just real slow.  I'm only pulling 2 fields:  CASE_ID(which
is 
indexed and has criteria) and DESC(which is the memo field no criteria).

Not sure if anyone has a number...but is there a ballpark number of
expected 
records per minute/second?  Just curious if I'm really slow...or if this
is 
the norm.

Thanks,

Mark

>From: Gary Kjos <garykjos at gmail.com>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Access and TaskManager
>Date: Thu, 7 Apr 2005 14:05:24 -0500
>
>What's the ODBC connection too? When I do ODBC to Oracle, Access sends 
>the query info to the Oracle system and the query is really run on the 
>server, not on the Access PC. So the Access PC just sits there waiting 
>for the server to send the results of the query down the pipe. Until 
>the server is ready, the Access PC just waits, hence the low CPU 
>utilization, it's just killing time. The way to speed it up is to 
>optomize the query that is sent to the Oracle engine - joining and 
>putting criteria on indexed fields and such.  Not much else you can do 
>I'm afraid.
>
>On Apr 7, 2005 1:52 PM, Mark A Matte <markamatte at hotmail.com> wrote:
> > Hello All,
> >
> > I'm doing some large data pulls with A97 via ODBC...I know it takes 
> > a
>long
> > time anyway...but when looking at the windows task manager, only 1-2

> > percentCPU usage is indicated for Access.
> >
> > Just curious, how to make this thing go any faster.  A month ago we
>talked
> > about the 'ADO' thing...but unless I did something wrong...it didn't

> > go
>any
> > faster.
> >
> > FYI...I'm talking a little over 1 million records...and memo/blob 
> > fields
>are
> > involved.  Any ideas?
> >
> > Thanks,
> >
> > Mark A. Matte
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>--
>Gary Kjos
>garykjos at gmail.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list