View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000870 | savapage-core | [All Projects] General | public | 2017-09-26 20:42 | 2018-04-30 16:11 |
| Reporter | rijkr | Assigned To | rijkr | ||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.9.12 | ||||
| Target Version | 1.0.0 | Fixed in Version | 1.0.0 | ||
| Summary | 0000870: Optimize Document Log cleanup | ||||
| Description | IST: 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 | ||||
| Tags | No tags attached. | ||||
| 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 |
