[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