Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Increase speed of container flow generation by reducing I/O operations #173

Open
1kastner opened this issue Feb 22, 2023 · 2 comments
Open
Labels
enhancement New feature or request low-priority This involves a major time investment at probably minor improvements

Comments

@1kastner
Copy link
Owner

Is your feature request related to a problem? Please describe.
Currently, the generation of the container flows takes a while, especially for larger datasets.
Most likely, this is due to the I/O operations - that needs to be verified first.

Describe the solution you'd like
The ORM wrapper peewee offers some options to tune it.
Some are presented at https://docs.peewee-orm.com/en/latest/peewee/querying.html#bulk-inserts
Maybe some of these methods can be introduced with minor changes in code?

Describe alternatives you've considered
Keep things as they are and learn to be patient.

@1kastner
Copy link
Owner Author

Instead of bulk inserts, maybe we can start the application with an in-memory database that we back-up to the hard drive once all data is generated. More information on how to back up in-memory databases can be found at https://stackoverflow.com/questions/67654486/how-to-backup-peewee-database-sqlitequeuedatabase-programatically

@1kastner
Copy link
Owner Author

1kastner commented Sep 9, 2023

See main...lucedes27:conflowgen:Reduce-I/O-Operations-in-Container-Flow-Generation for one attempt how to achieve this. It seems like I/O operations are not the culprit but rather peewee itself. Better profiling is needed to be sure about this though.

@1kastner 1kastner added enhancement New feature or request low-priority This involves a major time investment at probably minor improvements labels Sep 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request low-priority This involves a major time investment at probably minor improvements
Projects
None yet
Development

No branches or pull requests

1 participant