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

  • How to Say NO to Stakeholders, Clients, and Sponsors
    by Mike Clayton on 10 Luglio 2025 at 4:55

    Do you know how to say No to your stakeholders, clients, and sponsors and leave them feeling good? Because we can’t say yes to all of them! The post How to Say NO to Stakeholders, Clients, and Sponsors appeared first on OnlinePMCourses.

  • PM CPD and PDUs: How to Keep Ahead with Your Professional Development
    by Mike Clayton on 7 Luglio 2025 at 4:34

    A Project Manager is like any other professional. To take your career seriously, you’ll undertake Continuing Professional Development (CPD). The post PM CPD and PDUs: How to Keep Ahead with Your Professional Development appeared first on OnlinePMCourses.

  • Who are the Top 25 Project Stakeholders?
    by Mike Clayton on 3 Luglio 2025 at 4:55

    In every project, some stakeholders turn up again and again. Here are my top 25 types of project stakeholders, starting with the most common. The post Who are the Top 25 Project Stakeholders? appeared first on OnlinePMCourses.

  • Project Management Interviews: My Top 15 Videos to Watch Now
    by Mike Clayton on 30 Giugno 2025 at 4:55

    In the four years since I recorded my first project management interview, I’ve had over 60 wonderful conversations with astonishing Project Professionals. In this article, I want to highlight my top 15. Depending on when you read this, you may not see 60 interviews on my Conversations & Interviews playlist. Not all of them have The post Project Management Interviews: My Top 15 Videos to Watch Now appeared first on OnlinePMCourses.

  • What is the Analytical Hierarchy Process? And How Does it Work?
    by Mike Clayton on 26 Giugno 2025 at 5:00

    In this video, I answer the question, ‘What is the Analytical Hierarchy Process?’ and look at how we carry it out, with a worked example. The post What is the Analytical Hierarchy Process? And How Does it Work? appeared first on OnlinePMCourses.

  • Project Reporting Best Practice You Need to Know to Get Better Results
    by Mike Clayton on 23 Giugno 2025 at 4:55

    The cadence of your project reporting cycle sets the rhythm of your project. Quarterly, monthly, weekly – it’s time for your next report. The post Project Reporting Best Practice You Need to Know to Get Better Results appeared first on OnlinePMCourses.

  • Managing Benefits: Steve Jenner – the expert on Project Benefits Management
    by Mike Clayton on 19 Giugno 2025 at 4:55

    Benefits Management is a critical Project and Program discipline. Steve Jenner is the author of the Managing Benefits book and certification. The post Managing Benefits: Steve Jenner – the expert on Project Benefits Management appeared first on OnlinePMCourses.

  • Stakeholder Engagement Domain: What does a Project Leader Need to Know?
    by Mike Clayton on 16 Giugno 2025 at 4:55

    Stakeholder engagement is the most important part of the project management skill set. Here is my guide to the stakeholder engagement domain. The post Stakeholder Engagement Domain: What does a Project Leader Need to Know? appeared first on OnlinePMCourses.

  • Team Building – How to Build Your Project Team
    by Mike Clayton on 12 Giugno 2025 at 4:55

    As project professionals, we often need to build and maintain effective teamwork. So, in this video, let’s look at how to do team building. The post Team Building – How to Build Your Project Team appeared first on OnlinePMCourses.

  • Project Risk Management: Do You Know the 5 Hidden Estimating Flaws?
    by Mike Clayton on 9 Giugno 2025 at 4:55

    The principles of project risk management will be familiar to project managers. But it’s hard to assign likelihoods to the risks we identify. The post Project Risk Management: Do You Know the 5 Hidden Estimating Flaws? 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
en_GBEnglish
en_GBEnglish it_ITItalian