Report Performance

[maryb0224]

Crystal Reports v.8
SQL Server 7.0
ODBC connectivity
WINNT workstation

When a domain administrator on our network runs a crystal report, the records are retrieved from the database server in two minutes. They are "hashed through" on the workstation side - and at the two minute mark, 330,000 records have been read.
When a regular end user runs the exact same report on the exact same workstation, the records are still retrieved from the database server in two minutes. They are "hashed through" on the workstation side - and at the two minute mark only 12,000 records have been read.
The regular end user has full-control to all drives and directories on the workstation.
As a further test, I added the Domain Admins group to a different regular end user, and when that user ran the report, they had the same result as the first domain admin running the report.
Why is this??

 

[synapsevampire]

That is very odd... It doesn't sound like the same report.

If you add the user with the bad results to the Domain Admins, do they get a better response time?

I've never heard of this, perhaps the network is throttled down for certain users.

Are you using a System DSN for the ODBC, or can they be different (User dsn)? Perhaps there's a setting on the ODBC driver which is different, I've never heard of this before.

Sounds like you addressed the temp file issue, which could cause problems for such a mamoth report.

If you get a resolution, please post it.

-k