Project Management
News about the PMP certification
OnlinePMCourses Online Project Management Video Courses to Build Your Project Career
- What’s the Difference: Risk Appetite – Risk Tolerance – Risk Capacity?by Mike Clayton on 18 Aprile 2024 at 4:55
How much risk will your project take on? There are 3 similar measures. What’s the difference: Risk Tolerance, Risk Appetite, & Risk Capacity? The post What’s the Difference: Risk Appetite – Risk Tolerance – Risk Capacity? appeared first on OnlinePMCourses.
- New Project Manager? 6 Parts to My Most Important Adviceby Mike Clayton on 15 Aprile 2024 at 4:55
Congratulations! You’re a New Project Manager. Let’s take a moment to go through my most important advice. I’ve divided it into six areas. The post New Project Manager? 6 Parts to My Most Important Advice appeared first on OnlinePMCourses.
- What is Expected Monetary Value? (EMV)by Mike Clayton on 11 Aprile 2024 at 4:55
In this video, I answer the question, what is Expected Monetary Value, EMV? And we look at its use in risk management and decision theory. The post What is Expected Monetary Value? (EMV) appeared first on OnlinePMCourses.
- Risky Analysis: Pitfalls and Good Practices in Estimating Likelihoodby Mike Clayton on 8 Aprile 2024 at 4:55
Basic risk analysis is easy to understand. But there’s one pitfall that too many Project Managers fail to avoid: estimating likelihood. The post Risky Analysis: Pitfalls and Good Practices in Estimating Likelihood appeared first on OnlinePMCourses.
- My Top 10 Project Management YouTube Channel Recommendations for 2024by Mike Clayton on 4 Aprile 2024 at 4:55
I’ll assume you like Project Management videos. So, If you want to expand your repertoire of channels, here’s my top 10 list for 2024. The post My Top 10 Project Management YouTube Channel Recommendations for 2024 appeared first on OnlinePMCourses.
- Change Control 101 – Your Guide to Project Change Controlby Mike Clayton on 28 Marzo 2024 at 5:55
When your project is going well, but a stakeholder changes their mind, this is a job for Project Change Control. The post Change Control 101 – Your Guide to Project Change Control appeared first on OnlinePMCourses.
- Work Breakdown Structure: How to Build One Effortlessly with a Mind Mapby Mike Clayton on 25 Marzo 2024 at 5:55
A Work Breakdown Structure (WBS) is a hugely valuable Project Management tool. Make it easy for yourself. Create your WBS with a Mind Map. The post Work Breakdown Structure: How to Build One Effortlessly with a Mind Map appeared first on OnlinePMCourses.
- What’s the Difference between PERT and CPM?by Mike Clayton on 21 Marzo 2024 at 5:55
PERT and CPM are two forms of Network Chart that are represented differently, and take different approaches to calculating schedules. The post What’s the Difference between PERT and CPM? appeared first on OnlinePMCourses.
- Future of Work: What’s in PMI’s 2024 Pulse of the Profession Report?by Mike Clayton on 18 Marzo 2024 at 5:55
We now have PMI’s 2024 Pulse of the Profession Report: The Future of Project Work: Moving Past Office-Centric Models. The post Future of Work: What’s in PMI’s 2024 Pulse of the Profession Report? appeared first on OnlinePMCourses.
- What goes into Tender Documents? (Getting a Competitive Tender Process Right)by Mike Clayton on 14 Marzo 2024 at 5:55
What you need to put into your set of tender documents, when you want to procure products or services by competitive tender. The post What goes into Tender Documents? (Getting a Competitive Tender Process Right) 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.