Admin: Created page with "=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 ser..."

2021-08-25T10:17:58Z

Created page with "=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 ser..."

New page

=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".

Performance - Revision history

Admin: Created page with "=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 ser..."

Admin: Created page with "=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 ser..."