[hbsmrusers] Opinions sought (swiftly) on HBSMR filtering

Fri Feb 22 09:54:52 GMT 2008

Hi folks
Ditto, I rarely manage to compact, and have no problems with filtering being particularly slow.  A couple of our installations are split between local and networked installs so the proposed method would need more regular maintenance by individuals as well, so happy to keep temporary tables as is. 

Sarah

-----Original Message-----
From: hbsmrusers-bounces at britarch.net
[mailto:hbsmrusers-bounces at britarch.net]On Behalf Of Nick Boldrini
Sent: 22 February 2008 09:49
To: List for users of the HBSMR software
Subject: RE: [hbsmrusers] Opinions sought (swiftly) on HBSMR filtering

I agree with Helen

I can only really compact when I am first in (or last out) so once a week is a good week. Filtering isn't annoyingly slow nor noticebly better after compacting at the moment, so I would suggest against the change

best wishes

Nick Boldrini
Historic Environment Record Officer
Heritage and Environment Section
Development and Countryside Service
Business and Environmental Services Directorate
North Yorkshire County Council
County Hall
Northallerton
DL7 8AH
Direct Dial (01609) 532331

Conserving North Yorkshire's heritage - encouraging sustainable access
www.northyorks.gov.uk/her 

This email is personal. It is not authorised by or sent on behalf of North Yorkshire 
County Council, however, the Council has the right and does inspect emails sent from 
and to its computer system. This email is the sole responsibility of the sender

>>> "Helen Wells (archaeology)" <Hwells at leics.gov.uk> 22/02/2008 09:45 >>>
Hello,

I never manage to do a repair and compact every day, I do it when I'm
the first one in (which happens fairly often but not every day...).

Helen Wells 
Assistant Planning Archaeologist/Historic Environment Record Officer 
Leicestershire County Council 
http://www.leics.gov.uk/historic_natural_environment_archaeology 

Please take note of our new telephone numbers: 
0116 305 8323 (Helen Wells, HER Officer) 
0116 305 8322 (Richard Clark, Senior Planning Archaeologist) 
0116 305 6217 (Lucy Griffin, Planning Archaeologist) 
0116 305 7035 (John Robinson, HLC Officer)

	-----Original Message-----
	From: hbsmrusers-bounces at britarch.net 
[mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Alison Bennett AAG
SMRO ES
	Sent: 22 February 2008 09:42
	To: List for users of the HBSMR software
	Subject: RE: [hbsmrusers] Opinions sought (swiftly) on HBSMR
filtering

	Hi Crispin,
	Here in Essex we would certainly be able to cope with compacting
everyday and would find the increased speed useful.
	Alison Bennett
	Team Leader
	Essex Historic Environment Record
	tel. 01245 437637
	e-mail: alison.bennett at essexcc.gov.uk 

	NOW BOOKING: 2008 ESSEX CONFERENCE
	"The Historic Environment of Essex: from earliest humans to the
20th century"
	19th - 21st September 2008
	Email Contact: Con2008HE at essexcc.gov.uk 

________________________________

	From: hbsmrusers-bounces at britarch.net 
[mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Crispin Flower
	Sent: 22 February 2008 09:34
	To: List for users of the HBSMR software
	Subject: [hbsmrusers] Opinions sought (swiftly) on HBSMR
filtering
	Importance: High

	Hi All
	I'm just finishing an urgent patch release, that fixes a few
bugs  (esp the thing for people on Access 2003 without service packs).

	I have a decision about how the index form filtering works...

	I can make filtering much faster, but the downside will be that
the HBSMR cpplication (HBSMR.MDB) will need to be compacted more
regularly, as the speed gain is accrued by storing temporary tables
internally, rather than in external temporary MDBs.
	Under heavy use, it would probably benefit from compacting once
a day.

	So does anyone have any feelings on the relative benefits of
having faster filtering against more maintenance? The speed improvement
will be perhaps 50-100%, and probably more noticable for SQL Server
users.

	thanks
	Crispin

	PS I'll be having to finalise this decision by about 11am today.

	Click here
<https://www.mailcontrol.com/sr/0G0UXf6XhdAgYNVV0qsVVR5c+ZZHQ+lm2xXpUQnp 
Szy3LV1bRvTSckBw0Wle3+5PhTMJrPYowrluPz4d!WbEYC7Y20zdmwOISAaTlVeN6vjIcC!q
tUQb5SujFaD5bjZPQ1nVM6RWHBNHmnalydV7qA9PftCaKDIMpJSv4vxM78X2zE5QFhuWm1RL
GJOjoTc7FYoWLF3nr+dmrlSFD0CVl846V9zsalNY>  to report this email as spam.

________________________________

	This email (including any attachments) is intended only for the
recipient(s) named above. It may contain confidential or privileged
information and should not be read, copied or otherwise used by any
other person unless express permission is given. If you are not a named
recipient, please contact the sender and delete the email from your
system. It is the recipient's responsibility to ensure that appropriate
measures are in place to check for software viruses. 

___________________________________________________________________________
Leicestershire County Council - rated a  'four-star' council by the Audit Commission
___________________________________________________________________________
This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications.   The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000.
The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council.
Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment.

WARNING

This E-mail and any attachments may contain information that is confidential or privileged, and is intended solely for the use of the named recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or any action taken is prohibited and may be unlawful.

Any opinions expressed are those of the author and not necessarily the view of the Council.

North Yorkshire County Council.
_______________________________________________
hbsmrusers mailing list
hbsmrusers at britarch.net
http://britarch.net/mailman/listinfo/hbsmrusers

The information in this email is confidential and  may be legally privileged. It is intended solely for the addressee. If you receive this email by mistake please  notify the sender and delete it immediately. Opinions expressed are those of the individual and do not necessarily  represent the opinion of Cambridgeshire County Council. All sent and received email from Cambridgeshire County Council is automatically scanned for the presence of computer viruses and security issues