Day End after bulk import

[devoted]

I have an import procedure that inserts approximately 10000 purchase orders, receipts and invoices (approximately 30000 documents). How long should the Day End after this typically take? It currently is on about 8 hours. Do I have any options for speeding this up?

Thanks in advance.

 

[Jay Converse]

It depends on your hardware, database, and Accpac version, none of which you mentioned.

 

[devoted]

Thanks,

Sage 300 2012 (PU3)
SQL Server 2012

Unfortunately it is a very low spec box in the interim:
64bit Windows 2008 R2, 8GB RAM, Intel Xeon E5620 2.4GHz.

 

[Jay Converse]

Make sure your Recovery Model is set to simple, and run day-end directly on the SQL server.

 

[devoted]

I am running it directly on the server hosting the database but the recovery model is full. I will amend and give it a try.

Thanks for your assistance.