Report not running?

[EscapeUK]

I have a couple of reports that take under half an hour to run in my office however on two completley unconnected sites they a run over night and still have not completed by the morning.

What differences could there be in the setups for this to happen?

 

[CrystalVisualBOracle]

IT could be a lot of things. If you can, try taking out your query from each of the reports and running them directly against the database. That's one way to figure out whether it's a performance issue with the database. Sometimes it can be as simple as someone putting an index on a field in your database and never remembering to put the same index on the other databases. It may also be a network problem. Basically you're going to have to figure out the differences between your system and the others and work your way down the list.

Good luck
CrystalVisualBOracle :-V

 

[CrystalVisualBOracle]

Oh yeah, I forgot the most basic difference one usually finds between different systems, the amount of data in the database tables that are being queried. If your testing on a table with 1000 records and on the other systems there are 100,000 records, it's going to take significantly longer. You may have to have a DBA help you speed up your query or alter the tables to run faster for your query by incorporating indexes etc.

Good luck again

 

[EscapeUK]

Our reports are looking at sage. What would be the quickest way to run the query against it.

If this approach took along time to get the results I guess this would indicate some kind of network issue.