Topic: Write delay writing single records to a table
I'm not entirely sure what is causing this issue but I'm posting here just in case anyone has experienced and solved similar.
Quite simply, when editing a single record e.g. changing a determination field, it can take up to 2 minutes to write that data away (with the server 'Not responding') to the table. No matter what table I'm updating it takes ages to write.
This has been an annoying but not crucial issue for a while; however, post Larger Moth Atlas I will be updating from within Recorder 6 hundreds of records and this all of a sudden becomes a serious problem. It should take a fraction of a second to write, not 2 minutes.
If I test similar single record updates from a query in SSMS there's no delay.
Senior Data Manager, National Moth Recording Scheme