Articles Project Management
Plan Academy
Plan Academy Project Controls Training & Courses
- 4D Scheduling in Construction: Complete Guideby Faraz Khan on 10 September 2025 at 13:53
Picture this: You’re presenting your construction timeline to a room full of stakeholders—owners, architects, engineers, and city officials. Instead of…
- Construction Scheduling Challenges 2025: Shocking Industry Statsby Michael Lepage on 27 August 2025 at 14:04
Transcript Hey, friends. So when you think about construction scheduling as a whole, how well are we doing it? Are…
- Mastering the Primavera P6 Reflection Project Featureby Faraz Khan on 13 August 2025 at 13:48
Transform your project planning with safe testing environments and scenario analysis Why Every P6 User Needs to Know About Reflections…
- Plan Academy Community Q&As: Your Most Valuable Learning Momentsby Faraz Khan on 30 July 2025 at 17:49
The Plan Academy Community is where real collaborative learning happens. Beyond our structured courses, it’s in these authentic Q&A exchanges…
- Time Impact Analysis: The Critical Skill Every Construction Scheduler Needsby Faraz Khan on 16 July 2025 at 18:54
Are you struggling to quantify delays and defend time extension requests? Discover how Time Impact Analysis can transform your approach…
- Power BI Dynamic Dashboards: With Primavera P6 Integrationby Faraz Khan on 2 July 2025 at 19:53
In this blog, I’ll walk you through the process of setting up a Power BI dashboard with Primavera P6 data,…
- Microsoft Project: 5 Useful and Unique Featuresby Faraz Khan on 29 May 2025 at 17:12
Microsoft Project is a cornerstone tool for project managers, offering a robust suite of features to plan, track, and execute…
- Build Trustworthy Schedules that Inspire Performance – From Chaos to Clarityby Priyanka Mohan on 20 May 2025 at 15:24
How can you build trustworthy schedules? Just like trust in life takes time and consistency, trust in a project schedule also…
- Microsoft Project for Project Management: Simplify Your Workby Faraz Khan on 10 April 2025 at 20:40
Managing engineering and construction projects doesn’t have to be overwhelming. Between tight deadlines, strict budgets, multiple stakeholders, and ever-changing scopes,…
- What’s New in Primavera P6 Version 24.12by Rama Al Jaber on 3 April 2025 at 13:45
A new year means a new version of Primavera P6 for all on-premise users! Primavera P6 Version 24.12 is now…
- The Hidden Costs of Poor Project Controls: Is Your Construction Project at Risk?by Faraz Khan on 27 February 2025 at 8:46
Millions—sometimes billions—of dollars are on the line in Construction. One thing that separates the winners from the losers: project controls….
- Hydropower: North America’s Secret Weapon for a Cleaner Futureby Rama Al Jaber on 28 January 2025 at 18:38
What if I told you there’s a near-endless energy source sitting right under our noses, capable of powering millions of…
- Microsoft Project vs. Primavera P6 – Which is the Best Project Management Tool?by Faraz Khan on 7 January 2025 at 16:36
Wondering how Microsoft Project (MSP) stacks up against Oracle’s Primavera P6? Both are top-tier project management tools widely used in…
- Top 5 Reasons to Train in Project Controls in 2025by Rama Al Jaber on 17 December 2024 at 17:32
Whether managing schedules, budgets, or resources, the ability to forecast and adapt can be the difference between project success and…
- Power BI Cashflow Reporting – Exporting Data from Primavera P6by Faraz Khan on 31 October 2024 at 18:41
Leading up to the launch of our Power BI Foundations for Project Controls course, in this post, I will show…
- Power BI – Transforming Primavera P6 Data into Dynamic Reportsby Faraz Khan on 15 October 2024 at 15:30
Power BI is a powerful business analytics tool that transforms data into interactive, visually compelling insights. By integrating with tools…
- What’s New on the Plan Academy LMS in 2024by Joy Feddes on 1 October 2024 at 16:59
Have you noticed something different about our Learning Management System (LMS)? That’s right! We’ve made some exciting enhancements based on…
- Personal Leadership: Why is it Important for Schedulers?by Michael Lepage on 17 September 2024 at 17:12
As I write this, companies are hungry for schedulers across the globe. I talk with project controls managers every week,…
- Construction Sustainability Goals for 2025by Rama Al Jaber on 6 September 2024 at 15:21
By 2025, the construction industry is poised to implement several key sustainability goals that will shape its future. These goals…
- Project Delay Analysis: Best Methods and Limitationsby Faraz Khan on 22 August 2024 at 20:24
When project delays occur, it’s crucial to substantiate the impact, whether it’s related to time, cost, or both. The choice…
- Track Construction Delays with this Free Delay Log Trackerby Michael Lepage on 8 August 2024 at 14:00
Construction delays costs both Owners and Contractors millions of dollars each and every year. According to a Arcadis’ 2023 Global…
- Updating Primavera P6 with Data from Excelby Faraz Khan on 23 July 2024 at 18:14
Importing data from Excel can be challenging due to various factors, such as selecting the appropriate columns and formatting them…
- Construction Project Management: 10 Strategies to Master in 2024by Rama Al Jaber on 9 July 2024 at 17:31
Effective project management is crucial for the success of any endeavor. As we move further into 2024, construction managers are…
- Sustainability Highlights in 2024: 10 Projects to Keep Your Eye onby Rama Al Jaber on 26 June 2024 at 14:25
We’re seeing a profound shift towards sustainability in the Construction Industry in 2024. Mega projects around the world are setting…
Project Management
News about the PMP certification
OnlinePMCourses Online Project Management Video Courses to Build Your Project Career
- Continuous Delivery Explained: Faster, Safer Software Releasesby Mike Clayton on 16 October 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 October 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.
- Stop Wasting Time: James Garner Demos Agentic AI for PMs ⏱️by Mike Clayton on 9 October 2025 at 4:55
Agentic AI is astonishing. James Garner demonstrates what it can do for project management with just a few prompts. The post Stop Wasting Time: James Garner Demos Agentic AI for PMs ⏱️ appeared first on OnlinePMCourses.
- Alpha Project Managers: What Makes Some PMs the Very Best?by Mike Clayton on 6 October 2025 at 4:55
‘Alpha Project Managers: What the Top 2% Know that Everyone Else Does Not’ is a far better book than I had expected. The post Alpha Project Managers: What Makes Some PMs the Very Best? appeared first on OnlinePMCourses.
- How to Do a Training Needs Analysis: The Ultimate Guideby Mike Clayton on 2 October 2025 at 4:55
How do you assess what training is needed, and how best to deliver it? That’s the objective of TNA: Training Needs Analysis. The post How to Do a Training Needs Analysis: The Ultimate Guide appeared first on OnlinePMCourses.
- Use Soft Power: How to Improve your Project Management Negotiationby Mike Clayton on 29 September 2025 at 4:55
Hard and economic power are familiar. But how can you get people to do what you want, without incentives, sanctions, or coercion? Soft Power. The post Use Soft Power: How to Improve your Project Management Negotiation appeared first on OnlinePMCourses.
- Stop Playing Safe: Big Challenges for Fast Career Growthby Mike Clayton on 25 September 2025 at 4:55
If you want to fast-track your project management career growth, you can’t take it easy. Here are my top challenges to get you noticed. The post Stop Playing Safe: Big Challenges for Fast Career Growth appeared first on OnlinePMCourses.
- Project Management Dictionary: Top 20 Key Terms You Have to Knowby Mike Clayton on 22 September 2025 at 4:55
After 200 ‘What is…’ videos about Project Management jargon, I have picked out my top 20 Essential Project Management terms. The post Project Management Dictionary: Top 20 Key Terms You Have to Know appeared first on OnlinePMCourses.
- What is Agentic AI and Why Does it Matter?by Mike Clayton on 18 September 2025 at 4:55
What is Agentic AI, and what are AI Agents? Is Agentic AI the future of project management? And will Agentic AI take our jobs? The post What is Agentic AI and Why Does it Matter? appeared first on OnlinePMCourses.
- Fabulous Project Meetings: How to Make them Happen Every Timeby Mike Clayton on 15 September 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.
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.