View Issue Details

IDProjectCategoryView StatusLast Update
0000793OXID eShop (all versions)5. ------ UpdateApp / Update ------public2012-12-10 13:31
Reporterandreas_ziethen Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionno change required 
Product Version4.1.0 revision 17976 
Summary0000793: sql update script takes hours and hours and hours ...
DescriptionI tried to update an EE 4.0.1.0 to 4.1. Shop has about 22.000 articles and 1.500 categories. I executed the update.sql script from the shell and it took more then 6 hours to run before it was killed.
I tried that on a managed server at ProfiHost.

I'm not sure if all the modify statements for all tables are nessessary or not. But obviously they take a huge amount of time on a real-life shop database.
This at least should be mentioned in the readme of tht update patch.

Because in my case the update.sql execution was killed at some point something seems to be missing though the admin interface allways moans that system requirements are not fullfilled.
TagsNo tags attached.
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Activities

dainius.bigelis

2009-04-14 09:50

reporter   ~0000751

There are lot of updates queries, which affects lot of tables in DB. So please put a note about needed time in some online docu as a warning.

philipp_grashoff

2009-04-14 10:10

reporter   ~0000752

Added hint in update documentation.