Best ways to speed up P6?

Go to start

All programs

Select Microsoft SQL Server 2005

Then Microsoft SQL Server Management Studio

Server name is the name of your computer\PRIMAVERA

Authentication is SQL Server Authentication

Login: sa

Password is: Prima123Vera

Select Connect

On the left expand the databases and select pmdb$primavera

Uptop select New Query

on the right type this

update statistics project with fullscan ,all

update statistics task with fullscan, all

Then right click execute

Then type

exec sp_updatestats

Then right click execute

Hi John,

1.   If you are using SQL Server database - P6 PPM

Try running the following query for your database in SQL Server

exec sp_updatestats

then

update statistics project with fullscan ,all

update statistics task with fullscan ,all

https://docs.oracle.com/cd/E80667_01/English/Admin/p6_eppm_database_adm…

2.   Also, apparently there is a way to increase the Java virtual machine memory to 4GB in Environment Variables - try at your own risk - it didn't quite work for me btw

To increase the amount of memory available for Java virtual machine and Primavera on Windows operating system please follow these steps:

·    Go to Control Panel -> System and Security -> System  

·    Click on "Advanced system settings"  

·    Click on "Environment Variables..."  

·    Under the "System variables" group, please click on the button "New..."  

·  Enter:

oVariable name: _JAVA_OPTIONS

oVariable value: -Xms4096m -Xmx4096m

·  These settings increase Java virtual machine memory to 4GB

3.   Perhaps not an option now but for future, use different databases for different portfolios/projects etc.

4.   From my experience, you need at least 16GB RAM laptops (with modern processors), 8GB will slow down eventually. Point No. 2 is supposed to utilize the additional RAM but again I didn't see much success. Point No.1 normally provides the most success. 

1. work standalone not on a network

2. make sure there is no POBS data in the database

3. make sure that there are not any unecessary risk categories under Admin Categories some have weird symbols

4. Projects that are complete open them up and select file send project and email them to yourself then delted them from the 

database

John, if you're working on your own standalone P6 database - try creating a new database and use that. If the speed improves in the new database, then the issue lays with the original DB you were using, possibly its size, or perhaps some corruption.  If the speed in the new database is equally bad, then yes, it may mean issues with your PC.