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

  • Think You Know Risk? Top 15 Risk Management Myths Busted
    by Mike Clayton on 5 Giugno 2025 at 4:56

    If you are new to project management, you may come across some of the common risk management myths and not know how to respond. The post Think You Know Risk? Top 15 Risk Management Myths Busted appeared first on OnlinePMCourses.

  • Project Management Intuition: Why is it Essential and How to Strengthen Yours?
    by Mike Clayton on 2 Giugno 2025 at 4:55

    Intuition can cut through complex problems to get quick answers. In this article, learn what it is, why it matters, & how you can develop it. The post Project Management Intuition: Why is it Essential and How to Strengthen Yours? appeared first on OnlinePMCourses.

  • What are Anti-Patterns? And what are some common Project Management Anti-Patterns?
    by Mike Clayton on 29 Maggio 2025 at 5:09

    The term Anti-pattern has come into Project Management from the software engineering world, via the Agile community. But, what does it mean? The post What are Anti-Patterns? And what are some common Project Management Anti-Patterns? appeared first on OnlinePMCourses.

  • Turn Risk into Strength: How to Build a Better Project Risk Culture
    by Mike Clayton on 26 Maggio 2025 at 4:55

    A robust risk culture goes beyond a strong basic risk management process. But the rewards for the extra work are huge. The post Turn Risk into Strength: How to Build a Better Project Risk Culture appeared first on OnlinePMCourses.

  • Managing Portfolios: Steve Jenner on Portfolio Management
    by Mike Clayton on 22 Maggio 2025 at 5:10

    Steve Jenner literally ‘wrote the book’ on Managing Portfolios. He shares his experience and understanding as a Portfolio Management expert. The post Managing Portfolios: Steve Jenner on Portfolio Management appeared first on OnlinePMCourses.

  • Team Member Leaving Your Project? Here’s How to Handle It Smoothly
    by Mike Clayton on 19 Maggio 2025 at 4:55

    You may have to deal with a team member leaving your project. It’s never easy or pleasant. Although, it can sometimes be a bit of a relief! The post Team Member Leaving Your Project? Here’s How to Handle It Smoothly appeared first on OnlinePMCourses.

  • How to Value a Project: 7 Ways to Calculate Project Value
    by Mike Clayton on 15 Maggio 2025 at 4:51

    Value is a crucial concept in Project Management. But there are different ways to calculate it. Let’s look at 7 ways to calculate project value. This video is safe for viewing in the workplace. This is learning, so, sit back and enjoy The Main Ways to Calculate the Value of a Project Simple Value Calculations The post How to Value a Project: 7 Ways to Calculate Project Value appeared first on OnlinePMCourses.

  • Project Management Job: How to Start Your Career with Your First PM Job
    by Mike Clayton on 12 Maggio 2025 at 4:55

    Getting a Project Management job is a ‘chicken and egg’ problem. Mike Clayton shows you how to break the cycle and get your first PM role. The post Project Management Job: How to Start Your Career with Your First PM Job appeared first on OnlinePMCourses.

  • Top 10 Best Change Management Books
    by Mike Clayton on 8 Maggio 2025 at 4:05

    In this video, I have sifted my Change Management library for my top 10 best change management book recommendations. Let me know yours, in the comments.ext This video is safe for viewing in the workplace. This is learning, so, sit back and enjoy Recommended Change Management Books What Kit does a Project Manager Need? I The post Top 10 Best Change Management Books appeared first on OnlinePMCourses.

  • 4 Ways Personal Leadership Can Get You Better Project Results
    by Mike Clayton on 5 Maggio 2025 at 4:55

    What is it that makes people willing to follow you? This article is all about Personal Leadership. It’s what inspires people day-by-day. The post 4 Ways Personal Leadership Can Get You Better Project Results 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