...
- Data would not be real-time. However, this can be mitigated by frequent (daily) updates and we could build the capability to update cached data on demand.
Process
First let's determine whether performance of a typical query is sufficient. One caveat: We know database performance on UCJEPS needs to be addressed. Queries take far too long to run generally. Still, it seems unlikely that this will work. Uncached queries that get Darwin Core fields for a set of 53 objects take 18 seconds uncached (where label header like '%REEF POINT%'). ... where fieldlocstate='MA' takes 274 seconds.