Performance

Update Database Statistics

• If you use a large database (more than 100 000 records), check that statistics of data are up to date.
• This need an admin access to database server and some database administration knowledge.
• Check your database manual about "update statistics" for this.

Disable Canvas Feature

• Add into Home-Setup-Other the constant MAIN_DISABLE_CANVAS to value 1.
• This will disable canvas features that might be used by external modules and save one database request each time you go on page to show an object.
• However, if an external module used canvas, this will break this module.
• If you did not install and do not plan to install a complementary external modules, using this setup is safe.

Use a recent web browser

• More and more features used Ajax or javascript technologies to offer a modern look and feel.
• Such technologies are an important part of time taken to show a page and are best processed with a recent web browser.
• Gap between a version and the next one are sometimes very important,
• so think to use an optimized web browser and always the last stable version .

Search on beginning of field

• When you have a high number of products or third parties, you must disable the "autocomplete" search or lists will take a long time to appear.
• First thing to do is to go into setup of module Product and Third-party.
• change the option "Wait you have pressed n keys before loading list of product/third-parties/contact be loading combo list".