Database clean up ...


Message boards : Number crunching : Database clean up ...

Message board moderation

To post messages, you must log in.
AuthorMessage
Profile Bill F
Avatar

Send message
Joined: 12 Jan 13
Posts: 56
Credit: 13,621,437
RAC: 1,363
Message 8350 - Posted: 21 Apr 2024, 20:01:04 UTC
Is there a research reason why the number of Valid tasks in the database is so high ? After the task has been completed, returned and validated and the resulting science data collected most projects purge the completed tasks to keep their databases somewhat trimmed. This reduces size and both back up and search and indexing times.

Thanks
Bill F
In October 1969 I took an oath to support and defend the Constitution of the United States against all enemies, foreign and domestic;
There was no expiration date.


ID: 8350 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Profile JLDun
Avatar

Send message
Joined: 19 Jun 12
Posts: 16
Credit: 284,598
RAC: 396
Message 8351 - Posted: 21 Apr 2024, 20:41:47 UTC - in response to Message 8350.  
I agree. My current oldest listed (valid) tasks are from January 20. That makes three months of tasks....
ID: 8351 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote

Message boards : Number crunching : Database clean up ...