VERY URGENT! Large query taking 20mins

[Graham R Seach]

I guess I mis-read it.
Fair enough.We all do that from time to time.
He's not actually doing that; It was only an idea he was considering. I
agree that running it through Jet would definitely not improve performance.
Well, certainly when comparing to the sort of performance you're likely to
get from a database server, yes.
Now, now. Let's not get silly again.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

message
I'm sorry. when he says 'PT query' I assume that it is a query he is
using in a PIVOT TABLE.
I guess it's possible that he's using a PASSTHROUGH.

I guess I mis-read it.

But when he's talknig about this:
-----------------------------------------------------------
Simulate a ... view by pre-joining the tables in a local
Access table
-----------------------------------------------------------

I think that it's obvious that he's _NOT_ joining on the sybase side.
It looks to me like he's joining through linked tables.

Anything going to linked tables and then joining is going to run like
crap because jet is stupid.

Sorry

 

[a a r o n . k e m p f]

you don't need a materialized view.. but a standard view should help
you with your performance problems

I'd just make sure you're doing the join on the database server,
instead of through access