Blog PlanningPME

Easy-to-use resource scheduling software

Why should I opt for a SQL database ?

As we keep on developing new applications for new platforms and environments, we always make sure that our applications are compatible with a SQL database.

Why do we make this choice?

In application with PlanningPME, in terms of data protection, data security, performances and compatibility, a SQL database tops all systems. This is why all our applications can be bound to a SQL Server / SQL database.

Advantages of owning a SQL database with PlanningPME :

- More than 10 planners can use the schedule at the same time. Even if you need more people to access the schedule simultaneously, PlanningPME and SQL can manage all these concurrent accesses.
- SQL processes a very large amount of data very quickly. Your database can grow bigger and bigger, the performances remain the same.
- No extra migration cost (850€) if you need to use PlanningPME Web Access or PlanningPME Mobile. All the databases we host for our customers are SQL databases.

Drawbacks of the SQL system:

- Small delay after any operation on the database : creation, deletion of a task etc... (<1s)
- Database maintenance required, and SQL knowledge required for the technicians
- The database is not accessible via a single file, but by a connection string, or a customized shortcut

However, you might already have a defined data environment within your company. This is why PlanningPME is compatible with all these database types.

Comments are closed