Opened 4 years ago

Closed 4 years ago

#2339 closed enhancement (fixed)

Petascope - optimize SQL for Hibernate to read coverage basic metadatas

Reported by: Bang Pham Huu Owned by: Bang Pham Huu
Priority: major Milestone: 10.0
Component: petascope Version: 9.8
Keywords: Cc:
Complexity: Medium

Description

For example, if petascopedb contains 10,000 2D coverages. It takes ~90 seconds to fetch basic metadata for them to display for WCS GetCapabilities.

This could be optimized via HQL for Hibernate as from: https://stackoverflow.com/a/7913314/2028440

Change History (1)

comment:1 by Bang Pham Huu, 4 years ago

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.