Backend Information

Top  Previous  Next

Go to SI+ Backend and select the Information tab.

 

For more information, click on the different buttons

Rebuild IndexesPrestashopTasksManual UpgradeDisconnect UsersArchiveBackend_Information

 

Shared vs. Dedicated Mode and Their Impact on Computer Speed

1) Normal Operations: For everyday tasks such as posting invoices and performing lookups, the speed difference between Shared and Dedicated Mode is minimal.

 

2) Performance:

Dedicated Mode: Offers significantly better performance for intensive operations like Recalc Suggested and updating stock levels. It's also faster when multiple users are working at the same time..

 

3) Resource Usage:

Dedicated Mode: Consumes considerably more RAM and CPU resources compared to Shared Mode..

 

Some numbers to compare between the Shared mode and Dedicated mode.
Measurements were taken on database with 35 659 items with 7 years of transactions.
   
   - Purchase planning Calculate Suggested & Avg. Sales
        ○ Shared: 21m 38s
        ○ Dedicated: 6m 25s

    - Company > Data Health...>  Recalculate stock levels
        ○ Shared: 30m 56s
        ○ Dedicated: 6m 58s

    - Stock Ext Lookup
        ○ Shared: 5.40 s
        ○ Dedicated: 5.48 s

Rebuild Indexes

Rebuild Indexes is a maintenance function used to reorganize database indexes and improve overall system performance.

Over time, as data is added, modified, or deleted, indexes can become fragmented. This fragmentation can lead to slower performance when retrieving or updating data.

 

Running Rebuild Indexes will:

Optimize the structure of your database indexes

Improve speed and efficiency of data lookups

Help maintain system responsiveness, especially in large datasets

 

It's recommended to run this periodically—especially after bulk data imports, large updates, or extended periods of heavy use.

Keywords: Archive Data,Shared vs. Dedicated Mode