Opened 13 years ago

#1766 new enhancement

Permance improvement: remove IsNull check when get property from feature source

Reported by: hubu Owned by: hubu
Priority: low Milestone: 2.3
Component: Feature Service Version: 2.2.0
Severity: trivial Keywords: performance
Cc: External ID:

Description

IsNull check has some overhead, especially when the feature source connect to database such as Oracle, SQL Server, and etc. The solution is, catch all exceptions, if the property is indeed null, we will rethrow an MgNullPropertyValueException. The benifit for this solution is, we don't need to do IsNull check when get properties only if the properties is indeed null.

The test results show that this solution can decrease the query featue time about 3-5%. The test data is based on Oracle datasets, including 100 layers.

Attachments (1)

remove-isnull-check.patch (129.4 KB ) - added by hubu 13 years ago.
fix for this ticket

Download all attachments as: .zip

Change History (1)

by hubu, 13 years ago

Attachment: remove-isnull-check.patch added

fix for this ticket

Note: See TracTickets for help on using tickets.