Gary Kjos
garykjos at gmail.com
Thu Apr 7 14:05:24 CDT 2005
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