Join us this Friday for AI in Action at the Virtual Happy Hour! This free virtual event is open to all—enroll now on Academy and don’t miss out.

 

Optimization of create/update

Vote:
 

Hi all,

I am writing some code where I need to update, delete and create a large number of pages programmatically. We are talking about up to 10000 pages in total. The pages are scattered around the page tree, so I am not able to use for instance "DeleteChildren".

Are there any specific things to think about when doing stuff like this. Right now I am feeling that the process is pretty slow, for instance, it takes about a second per page to do a DataFactory.Delete.

Tips are greatly appreciated.

Best regards.

Emil 

 

#37881
Mar 23, 2010 15:24
Vote:
 

Which version of CMS ?

#37893
Mar 23, 2010 16:56
Vote:
 

Sorry, It's 5.2.375.236

#37899
Mar 23, 2010 21:01
Vote:
 

Made an import script that importet >100000 pages. Made is as a standalone application and talked to episerver throu a web service.

Worked as a charm, so don't worry :)

#37907
Mar 23, 2010 21:35
Vote:
 

Ok, just wondering since we did a lot of improvments in 5.2. I've used the same approach as Anders, created an app that talked to a custom web service on the site and imported up to a million pages. 64-bit machines and a fast SQL server does not hurt ;-)

#37947
Mar 24, 2010 14:45
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.