ATLANT ♆
Администратор
- Регистрация
- 09.05.21
- Сообщения
- 45.103
- Реакции
- 118.307
Название: SD Premium DB Indexes – boost database performance up to 50x v1.4
Автор: SuperDruid
This plugins sole purpose is increasing OpenCarts database performance and efficiency (both user and administrator area). It will decrease page generation time by multiple factors depending on server hardware and number of data (products/categories/orders) in database.
Many OpenCart performance/optimization extensions are focused on content caching techniques, which only mask real issues. Our extension actually deals with database optimization, which reduces database demand for memory and/or CPU power.
What are database indexes, and why do I need them?
When you want to find information in a book, fastest way is to find word or phrase in the back-of-the-book index. After you find it, you know on what page (or pages) is information you need. Alternative is to browse all pages and that takes time. Database indexes are used in a similar fashion, they provide information where requested information is located.
How it's made
Opencart makes lot of different DB queries. Before designing indexes, we detect and analyze slow performing queries. Each index is created for specific query and benchmarked, to ensure that it makes sense. If applicable, we will create indexes that speedup table joins, query filters and aggregate functions at the same time.
Продажник:
Автор: SuperDruid
This plugins sole purpose is increasing OpenCarts database performance and efficiency (both user and administrator area). It will decrease page generation time by multiple factors depending on server hardware and number of data (products/categories/orders) in database.
Many OpenCart performance/optimization extensions are focused on content caching techniques, which only mask real issues. Our extension actually deals with database optimization, which reduces database demand for memory and/or CPU power.
What are database indexes, and why do I need them?
When you want to find information in a book, fastest way is to find word or phrase in the back-of-the-book index. After you find it, you know on what page (or pages) is information you need. Alternative is to browse all pages and that takes time. Database indexes are used in a similar fashion, they provide information where requested information is located.
How it's made
Opencart makes lot of different DB queries. Before designing indexes, we detect and analyze slow performing queries. Each index is created for specific query and benchmarked, to ensure that it makes sense. If applicable, we will create indexes that speedup table joins, query filters and aggregate functions at the same time.
Продажник:
