Ticket #1019 (closed assessed: fixed)

Opened 7 years ago

Last modified 7 years ago

Ecospace scenarios take too long to save

Reported by: jeroens Owned by: jeroens
Priority: normal Milestone: Ecopath 6: release 6.3 BETA
Component: Database / Import Version:
Severity: major Keywords: ecospace, saving
Cc:

Description

Right now, map info is stored in a row for each cell. Saving this information takes too long - to the point of becoming unusable.

We may have to revert to storing maps as MEMO fields of some kind.

Change History

comment:1 Changed 7 years ago by jeroens

  • Status changed from new to closed
  • Resolution set to fixed

Ok, dunnit. Maps are saved to strings with a tad of smartness:

  • Maps are stored as strings, where:
    • cell values are formatted using en-US thousand separators (where applicable);
    • columns are separated by commas;
    • rows are separated by semi-columns;
    • and empty rows (rows without non-zero data) are saved as a single semi-colon.
  • Depth map saves at full resolution with an entry for each cell;
  • Every other map only saves either land cell values (for ports) or water cell values (all other layers);
  • Habitat, region and MPA maps are saved with their habitat, region or MPA. This opens the potential for overlapping habitats, regions and MPAs.
Last edited 7 years ago by jeroens (previous) (diff)
Note: See TracTickets for help on using tickets.