Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
gnumeric
gnumeric
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 376
    • Issues 376
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 2
    • Merge Requests 2
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • CI / CD
    • Repository
    • Value Stream
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • GNOME
  • gnumericgnumeric
  • Issues
  • #491

Closed
Open
Opened May 24, 2020 by boulshet@boulshetContributor

RFE : Performance improvement for "sample real-time data source" plugin with large data set and large calcutation

Background: i am using gnumeric and its great "sample real-time data source" plugin. Basically i have built a datasheet into which i automatically feed hundreds of new key-values each day. My issue is that the time processing is getting worse and worse as time goes on and the data set goes larger. It currently takes more than one hour for a full load.

Of course, i could try to optimize things a bit but a better approach might be sensible : As long as i understand how things go on, the automatic calculation is performed after each key-value loading. To put in with figures : if i disable automatic calculation, data are loaded in 2'30s Then, a manual calculation took a few seconds

Of course, i could just maually disable automatic calculation each time i load data. whether temporary or permanently, it wouldn't be very convenient.

RFE: i was wondering if it would be possible to automatically disable calculations for a few seconds each time a new data is loaded from "sample real-time data source" plugin and its atl_last function. A duration of one second would probably be big enough for a script to load the next value and reset the counter. The calculation would be performed only once when all data are loaded.

It would be really great and i can't really think of any drawback from an end user point of view. What do you think ?

Thanks for reading.

Edited May 24, 2020 by boulshet
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: GNOME/gnumeric#491