none
How many lines can MS project handle without much performance issues? RRS feed

  • Question

  • We are managing the master schedule for a large program and we current have an MS project file with around 7500 lines and it is growing. I use MS Project 2010 currently and is planning to migrate to 2013 shortly.

    I am concerned whether the growing size of the plans will cause performance issues ? Appreciate your valuable guidance.

    Regards,

    Pheba

    Wednesday, June 22, 2016 6:48 AM

All replies

  • Hi Pheba,

    Mostly it depend on the capacity of the server and the network. (Assuming that you are going for Project Server 2013 On-premises) Please read the recommendation for Project Server 2013.

    And in our environment we haven't set up the Sharepoint task sync. So that will increase the performance of the server, while having more than 7500 lines of Tasks.

    To know more about, what Project handle, Open the Project Professional 2013, in the top right corner you will find a "?" mark, search for "Project Specifications" and click on "Specifications for Microsoft Project", it will give you the details what project can handle.

    Hope this helps you.



    -SNKBalaji

    Wednesday, June 22, 2016 9:16 AM
  • Pheba,

    Actually a 7500 task master schedule isn't that large but the file size can grow very quickly as more resources, assignments, and custom attributes (e.g. formatting, views, etc.) are added. Also, if custom graphics (e.g. links or drawings) are added, the file can grow very large.

    You mention the use of a master file. If by that you mean you have several subprojects inserted into a dynamic master then you need to be award that in Project a linked structure is prone to corruption. You must never rename, move, overwrite or save off any of the files in the structure. All files should reside in a single directory on a local drive and not be operated over a network. If on the other hand by "master file" you simply mean a large single file then these precautions do not apply. However, if you find that your files is growing in size, you might want to take a look at the following Wiki article for ways to reduce file "bloat".

    http://social.technet.microsoft.com/wiki/contents/articles/32054.ms-project-clearing-file-corruption-andor-bloat.aspx

    John

    Wednesday, June 22, 2016 3:14 PM
  • As John said. I have regularly had unlinked master files with 10-12,000 tasks with no problems. just make sure your PC has at least 8GB of memory and at least 10% of free disk space.

    It also helps to have all the latest updates for Project, Office and Windows installed to fix known bugs.


    Rod Gill
    Author of the one and only Project VBA Book
    www.project-systems.co.nz

    Thursday, June 23, 2016 1:32 AM
    Moderator