1 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Long delays when saving a recording card

When saving data entered into a recording card, we're experiencing a long delay. For example, when just entered about 10 taxa via a recording card and it took around 3 minutes to save. Something is obviously not quite as it should be here. Are others experiencing delays, or is this unique to us?

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Long delays when saving a recording card

Hi Charles

I've just tried a simple test of this, the saving took about 3 seconds which admittedly could be faster, but is nothing like what you are experiencing. This was on a standalone PC running MSDE with 2GB RAM and a Core 2 Duo processor, so a reasonable modern PC spec. Looking at the SQL it generates, the thing that takes the longest is identifying which existing survey event matches the parameters of your record card, if any. This would be affected by the size of the database. My test environment has 342K taxon occurrences in it, so it might take longer if your dataset is much bigger though it shouldn't be that slow.

If you know how to use the Profiler tool that comes with SQL Server then grabbing a trace of the code that runs when you press the Save button would be a good idea.

Cheers

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Long delays when saving a recording card

We have just upgraded to 613 and are experiencing similar extended delays - 1-2mins for each record. Neither the database or the survey are particularly large.

It is saving across a network, but it has definately changed with the upgrade.

It would seem that changing location between records causes a delay, while just changing record type and taxon does not.

Can you provide further details of the profiler tool? Im only running SSMSE so dont know if its available through there.

Ta

MAtt

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Long delays when saving a recording card

I worked with John a few weeks ago to get to the bottom of this (it was indeed a bug) and I believe he got a fix into the codebase before he left Dorset.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

5 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Long delays when saving a recording card

Good good.

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

6 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Long delays when saving a recording card

Yes, I can confirm the next release should not have this problem.

John van Breda
Biodiverse IT

johnvanbreda's Website

7 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Long delays when saving a recording card

Other than making the database smaller, no, there's no workaround that I know if. The bigger question remains, though: was it a good sandwich?

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website