Ticket #135 (closed defect: fixed)

Opened 7 years ago

Last modified 4 years ago

Qgis slow to show the attribute table with lots of rows

Reported by: g_j_m Owned by: timlinux
Priority: minor: annoyance Milestone: Version 1.0.3
Component: Vectors Version: Trunk
Keywords: Cc: tutey@…
Platform Version: Platform: All
Must Fix for Release: No Awaiting user input: no

Description

Qgis is slow to show the attribute table when there are lots of rows. Improvements can probably be made in the vector provider code with regard to retrieving geometry attributes, particularily for postgres.

Change History

Changed 7 years ago by morb_au

As part of my changes to my working copy of the HEAD version, I have made a change to the way the attribute table loads.

If there is no selection on the active layer when the table is loaded, the full table is loaded. If there *is* a selection, only those selected rows are loaded.

This improvement may be useful until we can get a full MVC model going.

Changed 6 years ago by stephan.holl@…

  • must_fix set to No

Hello,

is this improvement already included in current trunk of QGIS? I would like to see this included soon since there are some persons having laaaaarge datasets living in geodatabases. This patch would certainly make it at least possible to work with attribute data on large datasets.

Are there any plans to implement this in the near future? Thanks for you comments.

Changed 6 years ago by wonder

There's no such improvement yet... attribute table needs to be redesigned to use Qt model/view architecture and that's quite a lot work. This redesign should ensure that only currently displayed attributes will be fetched from data source instead of loading everything when table gets opened.

I agree that this is important for any real usage of the table, but I don't know when/who will implement this...

Changed 6 years ago by stephan.holl@…

Hi wonder,

I interpreted the first comment from morb_au in that way, that his local copy of HEAD (probably outdated now) contains the described behaviour implemented. It would be nice to have a patch available for the meantime (as a workaround), so that large tables are manageable.

You are right, it should implemented in the future following the MVC-model.

Changed 6 years ago by timlinux

  • owner changed from gsherman to timlinux
  • status_info unset

Hi

I had similar issues in openModeller Desktop with large tables and I implemented them instead using Qt's interview framework and received a massive performance improvement. I will try to do the same in QGIS.

Changed 5 years ago by msieczka

  • cc tutey@… added

Changed 4 years ago by wonder

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

This has been fixed in 1.1 release with introduction of new model-based attribute table.

Note: See TracTickets for help on using tickets.