Opened 16 years ago

Closed 16 years ago

#222 closed enhancement (fixed)

SQLServerSpatial Provider: improve geometries fetching performance

Reported by: danstoica Owned by: danstoica
Priority: major Milestone: 3.3.0
Component: SQLServer Spatial Version: 3.3.0
Severity: 3 Keywords:
Cc: External ID:

Description

Currently when a larger than 5K geometry is hit, the geometries are unbound and all the subsequent batches are fetched as blobs. Note array fetch mechanism is in place.

This can be optimezed as:

  • enlarge the buffer size (say 10K)
  • fetch as blob only the truncated geometry
  • rebind back the array of geometries.

Change History (2)

comment:1 by danstoica, 16 years ago

Component: FDO APISQLServer Spatial

comment:2 by danstoica, 16 years ago

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