|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → Recorder Troubleshooting and Bug Reports → Circle Report
Please could someone with a large networked system check out the attached report for me. I can't see anything wrong with it, but it is failing on a users system when large amounts of data are involved. It would be helpful to know if this problem is confined to the one system or is more general.
I've been running this on one of our most dense areas - no errors yet, but it's still going after an hour and a quarter.
Currently calling [dbo].[LCReturnHierarchyLevel]
Thanks. Begins to looks like it might be a problem in the report then.
I had to kill it after about 2 hours as I needed to use Recorder.
I ran the circle report that I've used for a number of years on my network copy of R6 (on a standalone machine). On a test set of parameters it returned 3621 records in 25 seconds. When I ran CiExtra, 3621 records were returned but it took nearly 20 minutes to run with the same input parameters.
This turns out to be the User Defined Function which gets the taxonomic level. It works, but is not efficient , probably because it uses Index_ Taxon_Name which has no index. Changing this to use Nameserver does speed it up. Using a stored procedure might also help.
Forum → Recorder Troubleshooting and Bug Reports → Circle Report
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.