Articles

Plan Academy

Plan Academy Project Controls Training & Courses

By Andrea Di Dio, ago

News about the PMP certification

OnlinePMCourses Online Project Management Video Courses to Build Your Project Career

  • What is The Kraljic Matrix? Optimize Your Project Procurement
    by Mike Clayton on 13 Novembre 2025 at 5:55

    Poor procurement decisions are a major risk to your project, so the Kraljic Matrix is an essential tool in your project management toolkit. The post What is The Kraljic Matrix? Optimize Your Project Procurement appeared first on OnlinePMCourses.

  • How to Create Good Luck. Do You Want a Lucky Project Career?
    by Mike Clayton on 10 Novembre 2025 at 5:55

    Talent is wonderful, but success also needs good luck. So, what is the secret to a lucky project career? In this article, I’ll tell you. The post How to Create Good Luck. Do You Want a Lucky Project Career? appeared first on OnlinePMCourses.

  • Katie Taylor on The Future of Agile Project Management
    by Mike Clayton on 6 Novembre 2025 at 5:55

    Project Management is changing, and at the forefront is Agile. I met Katie Taylor to explore the future of Agile Project Management. The post Katie Taylor on The Future of Agile Project Management appeared first on OnlinePMCourses.

  • Expert 2-Phase Method: How to Craft a Great Project Manager CV
    by Mike Clayton on 3 Novembre 2025 at 5:55

    The gateway to your next great job is your CV, or resumé and there is an art, a craft, and a skill to writing a great Project Manager CV. The post Expert 2-Phase Method: How to Craft a Great Project Manager CV appeared first on OnlinePMCourses.

  • Mastering Project Closure Report: What You NEED in Your Final Doc
    by Mike Clayton on 30 Ottobre 2025 at 5:53

    I walk you through every critical component of a robust Project Closure Report, ensuring you wrap up every project properly. The post Mastering Project Closure Report: What You NEED in Your Final Doc appeared first on OnlinePMCourses.

  • Do you Know the 7 Habits of Successful Project Managers?
    by Mike Clayton on 27 Ottobre 2025 at 5:51

    You’ve probably heard of Stephen Covey’s bestseller, The 7 Habits of Highly Effective People. What about Highly Successful Project Managers? The post Do you Know the 7 Habits of Successful Project Managers? appeared first on OnlinePMCourses.

  • Is PMI-RMP Worth it? Top 10 Things to Know about it.
    by Mike Clayton on 23 Ottobre 2025 at 4:55

    PMI Risk Management Professional (PMI-RMP) is PMI’s certification for Risk Management. They designed it to offer a professional credential for project risk managers. For an in-depth discussion about the PMI-RMP certification and how to prepare for it: PMI-RMP: PMI’s Risk Management Professional Certification – with Harry Hall Take a look at my recommended PMI-RMP course. The post Is PMI-RMP Worth it? Top 10 Things to Know about it. appeared first on OnlinePMCourses.

  • Win Team Commitment on Your Project: Top 10 Ways
    by Mike Clayton on 20 Ottobre 2025 at 4:54

    If you want to supercharge your project team, you must win their commitment. It’s easy to spot: hard to do. Here are my top 10 strategies. The post Win Team Commitment on Your Project: Top 10 Ways appeared first on OnlinePMCourses.

  • Continuous Delivery Explained: Faster, Safer Software Releases
    by Mike Clayton on 16 Ottobre 2025 at 4:55

    What is continuous delivery, and how does it relate to project managers? In this video, we’re demystifying Continuous Delivery (CD). The post Continuous Delivery Explained: Faster, Safer Software Releases appeared first on OnlinePMCourses.

  • Things Go Wrong: Do You Know the Best Way to Handle Setbacks?
    by Mike Clayton on 13 Ottobre 2025 at 4:55

    Things go wrong. These setbacks can leave us feeling out of control and stressed. Do you know what to do, to handle it? The post Things Go Wrong: Do You Know the Best Way to Handle Setbacks? appeared first on OnlinePMCourses.

By Andrea Di Dio, ago

Primavera P6: reduce the local DB PPMDBSQLite to speed up application execution

Hi how are you? If you have come this far you may need to speed up the execution of the Oracle Primavera P6 application.
The short guide refers to the installations with the local Spring DB PPMDBSQLite.db and to the version P6 Professional R16.2 (x64) even if this procedure can also work with other versions.
For problems relating to Oracle Server DB on the network, ask your IT administrator for support.

We come to the problem, in practice to order and to speed up P6 I have removed many projects from Primavera but the size of the DB has never decreased.
As you see below, over time I had made copies of DB and you can see how the size has always increased, although it has sometimes canceled entire years of projects.
This I think is the problem that when I copy a Project, or when I import a large one, the import process never goes to the end, it either fails or I have to shut down the program and restart.

Like other databases, sqlite does not automatically reduce the size of data files when data is deleted. At least it doesn't by default.

To solve the problem, first make a backup copy of the DB itself, close P6, and then connect to the database with the administration console, or by running the command:

sqlite3 DBNamein your case I think it is
sqlite3 PPMDBSQLite.db

Once connected, the command must be launched
VACUUM;
which compresses the datafile
Eventually you exit the console with the command
.q

Unfortunately you probably don't have that command available on your PC, the sqlite3 command derives from a stand alone sqlite installation that is outside the P6 spring installation that has the DB driver already inside it.

So I installed the package:
sqlite-tools-win32-x86-3290000.zip
(1.71 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exeprogram, and the sqlite3_analyzer.exe program.
(sha1: f009ff42b8c22886675005e3e57c94d62bca12b3)

From the site
https://www.sqlite.org/download.html

AC: \ Users \ ofgod> cd \ Users \ ofgod \ Downloads

C: \ Users \ ofgod \ Downloads> cd sqlite-tools-win32-x86-3290000

C: \ Users \ ofgod \ Downloads \ sqlite-tools-win32-x86-3290000> sqlite3.exe \ TEMP \ PPMDBSQLite.db
SQLite version 3.29.0 2019-07-10 17:32:03
Enter ".help" for usage hints.
sqlite> VACUUM;
sqlite>
sqlite>
sqlite> .q

C: \ Users \ ofgod \ Downloads \ sqlite-tools-win32-x86-3290000>

Now the file is almost half the size and I hope the indexes have also been rebuilt.

Now P6 works better and is as fast as the first empty installation of the same application.

Good job, remember before doing this export and empty older projects from P6,

Close P6

Make a backup copy of PMDBSQLite.db

Launch sqlite3 and then the internal commands remembering the; after the statemend VACUUM.

good job

ADD

By Andrea Di Dio, ago