View Issue Details

IDProjectCategoryView StatusLast Update
0000870savapage-core[All Projects] Generalpublic2018-04-30 16:11
ReporterrijkrAssigned Torijkr 
PrioritynormalSeveritymajorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version0.9.12 
Target Version1.0.0Fixed in Version1.0.0 
Summary0000870: Optimize Document Log cleanup
DescriptionIST: Document Log cleanup take too much time for large data sets.
SOLL: Use SQL DELETE statements, instead of removing individual JPA entity objects. Also note that PostgreSQL automatically creates indexes on primary keys and unique constraints, but not on the referencing side of foreign key relationships. Therefore, define JPA indexes on foreign-key columns, so the right PostgreSQL schema DDL is generated.

Note: JPA/Hibernate generated DDL schema for PostgreSQL differs from the DDL generated for Apache Derby. The DDL for the latter *does* automatically create indexes for foreign key columns.

https://stackoverflow.com/questions/970562/postgres-and-indexes-on-foreign-keys-and-primary-keys
https://dba.stackexchange.com/questions/37034/very-slow-delete-in-postgresql-workaround#37095
https://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server
TagsNo tags attached.

Relationships

related to 0000869 closedrijkr savapage-server Add option to disable cleanup of Document Log at startup 
related to 0000878 closedrijkr savapage-core Upgrade database schema to 1.7 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-09-26 20:42 rijkr New Issue
2017-09-26 20:42 rijkr Status new => assigned
2017-09-26 20:42 rijkr Assigned To => rijkr
2017-09-26 20:43 rijkr Relationship added related to 0000869
2017-10-23 12:14 rijkr Severity minor => major
2017-10-23 12:14 rijkr Status assigned => resolved
2017-10-23 12:14 rijkr Resolution open => fixed
2017-10-23 12:14 rijkr Fixed in Version => 1.0.0
2017-10-23 12:14 rijkr Description Updated View Revisions
2017-10-23 12:14 rijkr Relationship added related to 0000878
2018-04-30 16:11 rijkr Status resolved => closed