Project Management
News about the PMP certification
OnlinePMCourses Online Project Management Video Courses to Build Your Project Career
- Fabulous Project Meetings: How to Make them Happen Every Timeby Mike Clayton on 15 Settembre 2025 at 4:55
Every project manager I have met spends a lot of their time in meetings. So, how can you Lead an excellent project meeting? The post Fabulous Project Meetings: How to Make them Happen Every Time appeared first on OnlinePMCourses.
- Data Analytics, AI, and the Future of Project Management – with Martin Paverby Mike Clayton on 11 Settembre 2025 at 4:55
What is the future of Project Management? Martin Paver is convinced it lies in AI and data analytics. Don’t miss this sensational interview! The post Data Analytics, AI, and the Future of Project Management – with Martin Paver appeared first on OnlinePMCourses.
- 10 Revealing Questions to find the Best Project Management Course for Youby Mike Clayton on 8 Settembre 2025 at 4:55
Do you want to find the best Project Management Course for you? Of course you do. It is an important decision. The post 10 Revealing Questions to find the Best Project Management Course for You appeared first on OnlinePMCourses.
- What is Whole Life Costing?by Mike Clayton on 4 Settembre 2025 at 4:55
In this video, I’ll answer the question, what is Whole-life costing? And I’ll consider how it compares to Life Cycle Cost. The post What is Whole Life Costing? appeared first on OnlinePMCourses.
- Leadership Books for Project Managers: What are my Top 10 Books?by Mike Clayton on 1 Settembre 2025 at 4:55
Project professionals must lead. Yet leadership isn’t in most project management books or courses. Here’s my list of great leadership books. The post Leadership Books for Project Managers: What are my Top 10 Books? appeared first on OnlinePMCourses.
- From Project Manager to Trusted Leader: 8 Routes to Long-Term Professional Successby Mike Clayton on 25 Agosto 2025 at 4:55
It’s easy for a project manager to be technocratic. To succeed, you must move from being an efficient textbook-follower to a trusted leader. The post From Project Manager to Trusted Leader: 8 Routes to Long-Term Professional Success appeared first on OnlinePMCourses.
- Use a Burndown Chart to Spot Problems | Top 7 Burndown Chart Anti-patternsby Mike Clayton on 21 Agosto 2025 at 4:55
Burndown chart anti-patterns signal issues in performance, estimation, or process. Here are 7 anti-patterns, what causes them, and what to do. The post Use a Burndown Chart to Spot Problems | Top 7 Burndown Chart Anti-patterns appeared first on OnlinePMCourses.
- Great Charisma: 7 Secrets for Being a Charismatic PMby Mike Clayton on 11 Agosto 2025 at 4:55
Does Project Management require charisma? We get things done through people: our team and our stakeholders. So, the answer is… ‘YES!’ The post Great Charisma: 7 Secrets for Being a Charismatic PM appeared first on OnlinePMCourses.
- How to Create a Burndown Chart in 10 Easy Stepsby Mike Clayton on 7 Agosto 2025 at 4:55
A Burndown chart is a way to visualize progress. It plots outstanding work against time. But, how can you build your own? The post How to Create a Burndown Chart in 10 Easy Steps appeared first on OnlinePMCourses.
- How to Get the Best from Your Project Team with Situational Leadershipby Mike Clayton on 28 Luglio 2025 at 4:55
Situational Leadership is a simple and compelling idea. If you want to get the best from someone, choose a leadership style that suits the situation. The post How to Get the Best from Your Project Team with Situational Leadership appeared first on OnlinePMCourses.
Articles Project Management
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 DBName
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
You must be logged in to post a comment.