locally processing large queries...can't alt-tab

[HarryStamper]

I often link to DB2 tables via ODBC... sometimes the tables are large and the queries can be slow.
I understand that the query is being processed locally and all that...many times I can't even alt-tab to do something else. I don't care if the query takes some time to process, its sitting there idle waiting for it to continue.
I am adding 1 MB RAM ...hopefully that will work.

 

[SkipVought]

I see four statements.

Is there a question lurking in there, somewhere???

Skip,

_[red][/red]

 

[PHV]

I am adding [!]1 MB[/!] RAM ...hopefully that will work
Not sure ... ;-)

 

[HarryStamper]

Question 1...Is that behavior normal, where I cant even alt tab...
Q2..Will 1 more MB help?

 

[SkipVought]

I dont' believe that the major issue is necessarily ODBC, or the amount of memory you have on your client.

If you are running a client-side database application, all the data is coming across the "wire" to your PC, BEFORE any criteria are applied, I do believe.

A server-side DB application would do the work on the remote server.

Skip,

_[red][/red]

 

[HarryStamper]

Problem is I work for a department...we have a large IT dept but they can't and don't have the resources to give the business area the info they need...so they bring in a programmer (me) and we use access via ODBC...which works very well...most of the time.

 

[Golom]

Just out of curiosity ... how do you add just 1 MB of RAM? Doesn't it come in increments of something like 256 MB? Did you mean 1 GB?

A dual-core processor may help. Windows can take advantage of that architecture to run other applications on one side of the processor while the other side is maxed out running your query.

 

[HarryStamper]

oops...yes I meant 1 GB. I try to use pass-thru queries when I can, but when the Managing director needs results for a meeting in 1 hour, i don;t have time to fiddle around writing native language SQL...I simply use the Access Query tool and away we go....
The frustrating part, is when something is processing, I can't open another access session, and if i realize something in the query is wrong, if I press ctrl-break, I get the hour glass cursor for what seems like an eternity.
I wish I can find someone out there with a dual core that does large queries locally.

Ed