Articles Project Management
Plan Academy
Plan Academy Project Controls Training & Courses
- 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…
- Streamline Your Project: Importing Data from Excel to Primavera P6 Effortlesslyby Faraz Khan on 11 June 2024 at 14:52
Preparing a schedule in Primavera P6 has traditionally been a time-consuming task, requiring manual data entry without the flexibility of…
- Primavera P6 Courses: 7 of the Most Popular Online Courses of 2024by Rama Al Jaber on 4 June 2024 at 13:14
In the dynamic world of project management, mastering tools like Primavera P6 is essential for success. With numerous training options…
- Schedule Delays in Construction Projects: 7 Key Factorsby Faraz Khan on 14 May 2024 at 17:30
Schedule delays are an ever-present challenge in construction projects, causing frustration, financial strain, and even legal disputes. Understanding the root…
- 6 New Features in Primavera P6 Professional Version 23.12by Rama Al Jaber on 16 April 2024 at 17:53
Oracle’s Primavera P6 Professional has long been a trusted project management software by industries worldwide to streamline processes and enhance…
- ALICE CORE: Unleashing Efficiency in Constructionby Rama Al Jaber on 2 April 2024 at 13:55
In the ever-evolving world of construction project management, staying ahead of the curve is paramount to success. With the emergence…
- Construction Sustainability Highlights 2023: Embracing the Futureby Michael Lepage on 10 February 2024 at 0:12
In the ever-evolving landscape of construction, sustainability has become more than just a buzzword—it’s a driving force shaping the industry’s…
- Gantt Charts: Mastering the Backbone of Construction and Engineering Project Managementby Rama Al Jaber on 9 February 2024 at 23:12
Gantt charts serve as the indispensable backbone of project controls and scheduling especially in the realm of construction engineering. The…
- New Features in Primavera P6 Version 22.12 That Will Change The Gameby Michael Lepage on 12 May 2023 at 16:34
Let’s talk about some of the most important new features in Primavera P6 version 22.12 that just dropped. There are…
- Creating Scenarios in Primavera P6? Here’s a Better Alternativeby Michael Lepage on 25 April 2023 at 14:34
We have been creating scenarios in Primavera P6 the same way for so long – and it completely sucks! Here’s…
- 7 Tips To Help You Create An Effective Project Status Reportby Michael Lepage on 11 January 2023 at 15:45
Put plainly, project status reports are difficult to write. It is a fact that project managers in different industries can…
- 5 Ways To Completely Revamp Your Project Productivity Styleby Michael Lepage on 30 November 2022 at 16:06
We all want to be and feel productive everyday. Somedays you feel like Thor, knocking off the tasks like he…
- P6 Schedule Comparison Tools: Which One Should You Use?by Michael Lepage on 10 November 2022 at 16:12
Comparing two Primavera P6 schedules is one of the most fundamental things that we should be able to as a…
- 4 Common Construction Bidding Errors And How To Avoid Themby Michael Lepage on 19 October 2022 at 16:00
Independent contractors are constantly seeking out and proposing bids in hopes of landing a construction job. Whether it is a…
- Physical Percent Complete in Primavera P6 – the Missing Guideby Nader Khorrami Rad on 5 October 2022 at 15:06
There are three different methods of calculating the actual progress of activities: Duration Percent Complete, Units Percent Complete, and Physical…
- Units Percent Complete in Primavera P6 – the Missing Guideby Nader Khorrami Rad on 28 September 2022 at 15:04
This article belongs to a series of articles about units percent complete fields of Primavera P6. As explained in the…
Project Management
News about the PMP certification
OnlinePMCourses Online Project Management Video Courses to Build Your Project Career
- How Personal Leadership Can Get You Better Project Resultsby Mike Clayton on 28 Ottobre 2024 at 5: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 How Personal Leadership Can Get You Better Project Results appeared first on OnlinePMCourses.
- What is a Benchmark, and How do we Do Benchmarking?by Mike Clayton on 24 Ottobre 2024 at 4:55
In this video, I answer two questions. 1. What is a Benchmark? and 2. How do we do benchmarking? The post What is a Benchmark, and How do we Do Benchmarking? appeared first on OnlinePMCourses.
- Project Resource Management: Part 1 of Your Comprehensive Guideby Mike Clayton on 21 Ottobre 2024 at 4:55
Nothing gets done unless people do it. And people need tools, materials, and a place to work. So, Project Resource Management is an essential skill set. The post Project Resource Management: Part 1 of Your Comprehensive Guide appeared first on OnlinePMCourses.
- What’s the Difference between Effectiveness and Efficiency?by Mike Clayton on 17 Ottobre 2024 at 4:55
We want to be effective and efficient. But, aren’t they really the same? No. There is a difference, and it won’t take long to explain! The post What’s the Difference between Effectiveness and Efficiency? appeared first on OnlinePMCourses.
- Project Human Resource Management: Complete Survey of its 6 Themesby Mike Clayton on 14 Ottobre 2024 at 4:55
You can’t get a project done without people. So you must manage your team well. That’s what Project Human Resource Management is all about. The post Project Human Resource Management: Complete Survey of its 6 Themes appeared first on OnlinePMCourses.
- Great Performance Review: How to Appraise Team Members’ Performanceby Mike Clayton on 10 Ottobre 2024 at 4:55
Even if performance appraisal during or at the end of a project is not a requirement on you, I believe it is a duty you should honor. The post Great Performance Review: How to Appraise Team Members’ Performance appeared first on OnlinePMCourses.
- Project Planning Mistakes and How to Avoid the 12 Most Scary Onesby Mike Clayton on 7 Ottobre 2024 at 4:55
There are many reasons why projects fail. One of the most common is when your plan is at fault. I survey my top 12 project planning mistakes. The post Project Planning Mistakes and How to Avoid the 12 Most Scary Ones appeared first on OnlinePMCourses.
- What Can AI Do for Project Managers? Dev Amratia is at the Leading Edgeby Mike Clayton on 3 Ottobre 2024 at 4:55
Dev Amratia is a leading thinker on Artificial Intelligence. We discuss what it can do now, and will be able to do in the near future. The post What Can AI Do for Project Managers? Dev Amratia is at the Leading Edge appeared first on OnlinePMCourses.
- Project Management Surveys: A Guide to Some of the Best to Readby Mike Clayton on 30 Settembre 2024 at 4:55
Surveys are hard to do well. So, a good survey is like gold dust. So, there are few worthwhile project management surveys out there now. The post Project Management Surveys: A Guide to Some of the Best to Read appeared first on OnlinePMCourses.
- What is the Stacey Matrix? Simple, Complicated, Complex, & Chaoticby Mike Clayton on 26 Settembre 2024 at 4:55
In this video, I answer the question, ‘What is the Stacey Matrix?’ and look at how it distinguishes Simple, Complicated, Complex, and Chaotic. The post What is the Stacey Matrix? Simple, Complicated, Complex, & Chaotic 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.