Ticket #834 (closed defect: fixed)

Opened 12 months ago

Last modified 11 months ago

Export layer data to SQLite becomes too slow

Reported by: wyylling Owned by: Ying Wang
Priority: major Milestone: 3.7.0
Component: SQLite Provider Version: 3.7.0
Severity: 3 Keywords:
Cc: External ID: 1449749.02

Description

1. Take the standard WW dump (TB_WW.dump also attached) and import it with TB2011 2. Generate graphic with the standard display model (also attached) 3. In Display manager select WW_Line with the right mouse taste and choose "Export Layer Data to SQLite..." 4. After 2 seconds, the sqlite file is created. 5. Take the same dump and import it with Map 2012 (inclusive structure updates) 6. Generate graphic with the standard display model (also attached) 7. In Display manager select WW_Line with the right mouse taste and choose "Export Layer Data to SQLite..."

Result: After 20 seconds the sqlite file is created. This is 10 times the time that was used with TB 2011

Expected result: The SQLite file should be created after 2 seconds.

Change History

Changed 12 months ago by stevenxu

  • status changed from new to closed
  • resolution set to fixed

Changed 11 months ago by stevenxu

The fix (r6471) is reverted in r6485 for it is by design and we should reuse all of FDO objects in caller side to gain the performance while inserting many features.

Note: See TracTickets for help on using tickets.