Ticket #1019 (closed assessed: fixed)

Opened 13 years ago

Last modified 13 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 13 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 13 years ago by jeroens (previous) (diff)
Note: See TracTickets for help on using tickets.