Articoli

Notizie sulla certificazione PMP

OnlinePMCourses Online Project Management Video Courses to Build Your Project Career

  • Top Secrets: 10 Things I Wish I Knew at 30
    by Mike Clayton on 20 Novembre 2025 at 5:55

    If I were 30 again, what are the ten most valuable things I wish I’d known at 30, to make me a better project professional, faster? The post Top Secrets: 10 Things I Wish I Knew at 30 appeared first on OnlinePMCourses.

  • 3 Important Truths: Why You are Ready for a Project Management Course
    by Mike Clayton on 17 Novembre 2025 at 5:55

    How do you know that you are ready for your first project management course? Don’t worry: you are. You know more about project management than you think. The post 3 Important Truths: Why You are Ready for a Project Management Course appeared first on OnlinePMCourses.

  • What is The Kraljic Matrix? Optimize Your Project Procurement
    by Mike Clayton on 13 Novembre 2025 at 5:55

    Poor procurement decisions are a major risk to your project, so the Kraljic Matrix is an essential tool in your project management toolkit. The post What is The Kraljic Matrix? Optimize Your Project Procurement appeared first on OnlinePMCourses.

  • How to Create Good Luck. Do You Want a Lucky Project Career?
    by Mike Clayton on 10 Novembre 2025 at 5:55

    Talent is wonderful, but success also needs good luck. So, what is the secret to a lucky project career? In this article, I’ll tell you. The post How to Create Good Luck. Do You Want a Lucky Project Career? appeared first on OnlinePMCourses.

  • Katie Taylor on The Future of Agile Project Management
    by Mike Clayton on 6 Novembre 2025 at 5:55

    Project Management is changing, and at the forefront is Agile. I met Katie Taylor to explore the future of Agile Project Management. The post Katie Taylor on The Future of Agile Project Management appeared first on OnlinePMCourses.

  • Expert 2-Phase Method: How to Craft a Great Project Manager CV
    by Mike Clayton on 3 Novembre 2025 at 5:55

    The gateway to your next great job is your CV, or resumé and there is an art, a craft, and a skill to writing a great Project Manager CV. The post Expert 2-Phase Method: How to Craft a Great Project Manager CV appeared first on OnlinePMCourses.

  • Mastering Project Closure Report: What You NEED in Your Final Doc
    by Mike Clayton on 30 Ottobre 2025 at 5:53

    I walk you through every critical component of a robust Project Closure Report, ensuring you wrap up every project properly. The post Mastering Project Closure Report: What You NEED in Your Final Doc appeared first on OnlinePMCourses.

  • Do you Know the 7 Habits of Successful Project Managers?
    by Mike Clayton on 27 Ottobre 2025 at 5:51

    You’ve probably heard of Stephen Covey’s bestseller, The 7 Habits of Highly Effective People. What about Highly Successful Project Managers? The post Do you Know the 7 Habits of Successful Project Managers? appeared first on OnlinePMCourses.

  • Is PMI-RMP Worth it? Top 10 Things to Know about it.
    by Mike Clayton on 23 Ottobre 2025 at 4:55

    PMI Risk Management Professional (PMI-RMP) is PMI’s certification for Risk Management. They designed it to offer a professional credential for project risk managers. For an in-depth discussion about the PMI-RMP certification and how to prepare for it: PMI-RMP: PMI’s Risk Management Professional Certification – with Harry Hall Take a look at my recommended PMI-RMP course. The post Is PMI-RMP Worth it? Top 10 Things to Know about it. appeared first on OnlinePMCourses.

  • Win Team Commitment on Your Project: Top 10 Ways
    by Mike Clayton on 20 Ottobre 2025 at 4:54

    If you want to supercharge your project team, you must win their commitment. It’s easy to spot: hard to do. Here are my top 10 strategies. The post Win Team Commitment on Your Project: Top 10 Ways appeared first on OnlinePMCourses.

Di Andrea Di Dio, fa

Primavera P6: ridurre il DB locale PPMDBSQLite per velocizzare l’esecuzione dell’applicazione

Ciao come va? Se sei arrivato fino a qui potresti avere bisogno di velocizzare l’esecuzione dell’applicazione Oracle Primavera P6.
La breve guida è riferita alle installazioni con il DB locale di Primavera PPMDBSQLite.db e alla versione P6 Professional R16.2 (x64) anche se questa procedura può funzionare anche con altre versioni.
Per le problematiche riferite a DB Oracle Server in rete chiedete supporto al vostro amministratore IT.

Veniamo al problema, in pratica per ordine e per velocizzare P6 ho rimosso molti progetti dal Primavera ma la dimensione del DB non è mai diminuita.
Come vedi sotto, nel corso del tempo avevo fatto delle copie de DB e si può vedere come la dimensione sia sempre aumentata, seppure abbia a volte cancellato intere annualità di progetti.
Questo penso che sia il problema per cui quando copio un Progetto, o quando ne importo uno grande il processo di import non mi va mai alla fine, o fallisce oppure devo spegnere il programma e riavviare.

Così come altri database, sqlite non riduce le dimensioni dei datafile automaticamente quando vengono cancellati i dati. Quantomeno non lo fa per default.

Per risolvere il problema prima effettuati una copia di sicurezza de DB stesso, chiudi P6, e poi connettiti al database con la console di amministrazione, ovvero lanciando il comando:

sqlite3 NomeDBnel tuo caso penso sia
sqlite3 PPMDBSQLite.db

Una volta connesso, va lanciato il comando
VACUUM;
che comprime il datafile
Alla fine si esce dalla console con il comando
.q

Purtroppo probabilmente non hai quel comando disponibile sul PC, il comendo sqlite3 deriva da una installazione sqlite stand alone che esula dall’istallazione di primavera P6 che ha il driver del DB già al suo interno.

Per cui ho installato il pacchetto:
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)

Dal sito
https://www.sqlite.org/download.html

A.C:\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>

Ora il file è quasi la metà come dimensione e spero siano stati ricostruiti anche gli indici.

Adesso P6 lavora meglio ed è veloce come ala prima installazione vuota dello stesso applicativo.

Buon lavoro, ricorda prima di fare questa operazione esporta e svuota progetti non più recenti da P6,

Chiudi P6

Fai una copia di sicurezza del PMDBSQLite.db

Lancia sqlite3 e poi i comandi interni ricordando il ; dopo lo statemend VACUUM.

Buon lavoro

A.D.D.

Di Andrea Di Dio, fa