V
Vihrea
Hi All,
I'm having some performance issues with someoe trying to retrieve data from
my SQL 2000 db using ACC2003 as the front end via linked tables.
I'd like to know more at a technical level about how ACC compiles an data
access path, hands it off os SQL2K , how SQL interprets it and then returns
the dataset.
Finally, exactly what is ACC2003 then processing? Is it the entire dataset
(>6million rows). Perhaps this user needs to redesign the query. I don;t
know enough about ACC's behavior yet.
Any references out there?
======================
JG
Systems/DBA Supervisor
Vermont Agency of Transportation
GIAC Security Certified
MCSE, CCNA, .NET
I'm having some performance issues with someoe trying to retrieve data from
my SQL 2000 db using ACC2003 as the front end via linked tables.
I'd like to know more at a technical level about how ACC compiles an data
access path, hands it off os SQL2K , how SQL interprets it and then returns
the dataset.
Finally, exactly what is ACC2003 then processing? Is it the entire dataset
(>6million rows). Perhaps this user needs to redesign the query. I don;t
know enough about ACC's behavior yet.
Any references out there?
======================
JG
Systems/DBA Supervisor
Vermont Agency of Transportation
GIAC Security Certified
MCSE, CCNA, .NET