Importing takes too long

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

thinwath
Posts: 16
Joined: Thu Apr 26, 2007 1:37 pm

Importing takes too long

Post by thinwath »

Hi Guys,

I updatet my openemm version to the latest build and now I'm recognizing this problem:

My imports take too much time imo. For about 7000 recps it takes over 20mins. In earlier versions I could import nearly 20.000 recps in a couple of minutes.

I'm checking at my imports for duplicates and refreshing old recps.

Anyone else which such "problems"? Maybe some of you could give me an advice.

Regards
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

Do you have an index on the email field?
OpenEMM Maintainer
thinwath
Posts: 16
Joined: Thu Apr 26, 2007 1:37 pm

Post by thinwath »

ma wrote:Do you have an index on the email field?
yes there is an index for the email field.
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

Sorry, I do not know what went wrong, however we will replace the existing (kind of messy) import code with completely rewritten import code and JSPs optimized for usability in release 5.6. Maybe this will help.
OpenEMM Maintainer
thinwath
Posts: 16
Joined: Thu Apr 26, 2007 1:37 pm

Post by thinwath »

ma wrote:Sorry, I do not know what went wrong, however we will replace the existing (kind of messy) import code with completely rewritten import code and JSPs optimized for usability in release 5.6. Maybe this will help.
well... this isn't an answer like I excepted ;) I installed a brand new system on a Win 2003 Server, same story. 8k recps takes now nearly 40mins.

I can't imagine that I'm the only one with this issue.

Is there any roadmap? Or any date for the next release?

edit:
Is there any possibilty to downgrade from 5.5.1 to 5.4.x or lower?
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

OpenEMM Maintainer
Post Reply