Skip to Content
0
Former Member
Aug 21, 2015 at 08:26 AM

Media and MediaContainer impex performance issue.

527 Views

Hi,

Importing media is taking too long up to 3 hrs in my case,can any one please suggest the solution for this problem. This is happening for me after migrating from 4.5.12 to 5.5.1.2 . We have around 0.3 million records and imp-ex is processing at 100 items/s at an avg. In old version it processes the same amount of record in 1000 items/s .

We are recently working on migration of hybris 4.5.12 to 5.5.1.2 . We are using same impexes of 4.5.12. But the import time of media data is increased by 10 times. We did not do any change. Sample impex is :

$catalogVersion=catalogVersion(catalog(id[default='']),version[default=''])[unique=true,default=''] $medias=medias(code, $catalogVersion)

"#% impex.test.feeds.context.MCImportContext mcContext = new impex.test.feeds.context.MCImportContext ();"

INSERT_UPDATE MediaContainer;$catalogVersion[pos=300];qualifier[unique=true, pos=301];mediaType[pos=302]; "#%beforeEach: mcContext.prepareMediaContainers(line);" "#% impex.includeExternalData(new FileInputStream(System.getProperty(""HYBRIS_DATA_DIR"") + ""/feed/incoming/IMAGE_CSV.csv""), ""utf-8"", new char[]{','}, 0, -1);" "#%beforeEach:end"

"#% impex.info(""> Time Taken to import Media Containers >""+((System.currentTimeMillis()-startTime)/1000)+"" Sec"");"

This import is very slow with latest hybris version.

$catalogVersion=catalogVersion(catalog(id[default='']),version[default=''])[unique=true,default=''] $medias=medias(code, $catalogVersion)

"#% impex.test.feeds.context.MCImportContext mcContext = new impex.test.feeds.context.MCImportContext ();"

------------------------------------------------------------ CREATING MEDIA

% startTime = System.currentTimeMillis();"

INSERT_UPDATE Media;$catalogVersion[pos=300];code[unique=true, pos=301];mediaFormat(qualifier)[pos=302];url[pos=303];mediaContainer(qualifier, $catalogVersion)[pos=304] "#%beforeEach: mcContext.prepareMedia(line);" "#% impex.includeExternalData(new FileInputStream(System.getProperty(""HYBRIS_DATA_DIR"") + ""/feed/incoming/IMAGE_CSV.csv""), ""utf-8"", new char[]{','}, 0, -1);" "#%beforeEach:end"

"#% impex.info("">> Time Taken to import Media : ""+((System.currentTimeMillis()-startTime)/1000)+"" Sec"");"

Above one also take too long to execute. it is 10 times more than old hybris version.

Please , help us with the possible cause and solution.

Regards, Jeejo