Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030411Retail ModulesWeb POSpublic2015-07-23 03:172015-08-14 12:25
Reporterrbianchini 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product VersionRR14Q2.2 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Support ticket36412
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030411: FixDataIssue27425 takes a very long time when the tables have more than 1.000.000 rows
DescriptionFixDataIssue27425 takes a very long time when the database have tables with more than 1.000.000 rows

Table fin_payment_scheduledetail has 1.188.689 rows
Table fin_payment_schedule has 1.279.389
Table c_order has 1.357.985 rows
Table c_orderline has 2.059.103 rows
Table c_invoice has 91.832 rows
Table c_invoiceline has 1.877.481 rows
Steps To ReproduceTry to update from 14Q2.2 to 15Q1.5 in an environment with that ammount of data.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0030369 closed marvintm The modulescript FixDataIssue27425 is extremely slow with a moderately big amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-07-23 03:17rbianchiniNew Issue
2015-07-23 03:17rbianchiniAssigned To => Retail
2015-07-23 03:17rbianchiniOBNetwork customer => Yes
2015-07-23 03:17rbianchiniSupport ticket => 36412
2015-07-23 03:17rbianchiniResolution time => 1438120800
2015-07-23 03:17rbianchiniTriggers an Emergency Pack => No
2015-08-14 12:25marvintmRelationship addedduplicate of 0030369
2015-08-14 12:25marvintmStatusnew => closed
2015-08-14 12:25marvintmResolutionopen => duplicate

There are no notes attached to this issue.