1

Re: Recording card load time

Are anyone elses recording cards (through "enter species for a place") taking an inordinate amount of time to load (~50 secs on my machine)?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

2

Re: Recording card load time

I opened the largest recording card that was readily to hand (BRC_VascPlants_NEng_RP24.crd) and it took about 10 seconds. It contains 1,029 taxa – if you open a recording card in Word you can use the Word count facility to count the number of 16 character taxon list item keys. This was on a 2 GHz laptop with 1 GB RAM running Windows XP Professional SP3 and a standalone installation of Recorder 6 v6.15.4.238 0000000T, the latest version. The second time I opened it, it only took 4 seconds. How many TLI keys are there in the recording card that took ~ 50 seconds to open?

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

3

Re: Recording card load time

There's no difference between one with ~1300 and one with ~13. They all seem to be taking 50 secs. to load (with a Celeron 2.4, 1GB, but it's the same on a much better PC).

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

4

Re: Recording card load time

Hi Charlie
Have you added lots of measurement units, measurement types or qualifiers by chance? Trying to spot what might be different about your setup since this certainly isn't normal. Does anyone else see this sort of slow loading of record cards?
Best Wishes

John van Breda
Biodiverse IT

5

Re: Recording card load time

Not a great deal of extra measurements I think, but I'll check. Quite a few record/sample types, but e.g. "enter a single species record" doesn't have any problems loading?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

6

Re: Recording card load time

Hi Charlie
How feasible would it be to either get a backup of your database available for me to test, or for you to run the SQL profiler tool (or find someone who can run it) to see what it is doing when the record card loads?
Best Wishes

John van Breda
Biodiverse IT

7

Re: Recording card load time

Maybe 100 abundance measurement qualifiers and 130 area measurement qualifiers, (twice as many as there should be - some merging needs doing) - is this a lot?

(and ~200 record types, 100 sample types)

Dan Jones administers our backend database, so he'd be the best person to run the profiler.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

8

Re: Recording card load time

Hi Charlie
Ok, let me know what Dan finds. He can send me the saved profile if you like.
I wouldn't say that 230 qualifiers is a lot, but looking at the code this could combine with a large number of units or measurement types to make it slow down a bit - just a thought that is worth investigating.

John van Breda
Biodiverse IT