请选择 进入手机版 | 继续访问电脑版

528站长之家

 找回密码
 立即注册
查看: 365|回复: 5

opencart 数据库加速插件SD Premium DB Indexes - boost database

[复制链接]

 成长值: 20002753

1751

主题

2746

帖子

167万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1678998

活跃会员积分达人永久会员(VIP)

发表于 2018-12-18 10:48:55 | 显示全部楼层 |阅读模式
opencart 数据库加速插件SD Premium DB Indexes - boost database performance up to 50x

本人从官方购买的原版,官方会定期提供升级版本,528站长论坛也会定期更新最新版本。

帖子更新日志:2019.09.13

superdruid_premiumdbindexes_3-1.5.1.ocmod.zip3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2
superdruid_premiumdbindexes_3-1.5.ocmod.zip3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0
superdruid_premiumdbindexes_2-1.4.ocmod.zip2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0
superdruid_premiumdbindexes-1.2.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
superdruid_premiumdbindexes-1.1.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
superdruid_premiumdbindexes-1.0.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
superdruid_premiumdbindexes-1.4.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
superdruid_premiumdbindexes_2-1.3.ocmod.zip2.0.0.0, 2.0.1.0, 2.0.1.1
superdruid_premiumdbindexes_2-1.2.ocmod.zip2.0.0.0
superdruid_premiumdbindexes_2-1.1.ocmod.zip2.0.0.0
BONUS-categories-speedup.ocmod2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0
superdruid_premiumdbindexes_2-1.5.ocmod.zip2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0
superdruid_premiumdbindexes-1.5.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
superdruid_premiumdbindexes_23-1.5.ocmod.zip2.3.0.0, 2.3.0.1, 2.3.0.2


56195a2f0bc92-resize-710x380.jpg


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.

Is this extension for me?

If you are not sure, contact us using http://support.cloud.superdruid.com.

This extension will speed up both user and admin area (see documentation). If you are using full page cache, user experience will remain same, but cache regeneration will be faster. It is best suited for shops that have many products/categories/orders. For additional speedup we recommend using "DBCache Unleashed" with this extension.

Find out more about our plugin here on official plugin page.

Please be sure to check side-by-side performance comparison between shops with our optimization extension and without it. Both OpenCart instances are of absolutely same configuration handling identical amount of categories and articles or for your convenience, please follow the link to optimized and unoptimized versions to see for yourself.

Benchmarks on our demo store show improvement of around 50 times with this extension implemented.

Why is speeding up my shop important?
There are many articles that cover this in detail. In short, faster shop means better business. You will sell more or/and spend less on hosting.




What customers say about Premium DB Indexes

Hello, I am fascinated by this module. At the initial installation of OpenCart, my site loaded in 1.0 to 1.15 seconds. After adding more than 400 categories and 50000 products, loading time increased from 1.15 to 5.10 to 5.5 seconds. Once I installed and turned on this module, the charging time is 1.35 to 1.4 seconds. Excellent work for developers, I appreciate the 5 Star Module and I recommend it for use if you have many categories and products. Thanks to the team, this is a great purchase for me!

Best Regards,
Milko Milkov
---------------
siptec

Wow, 100,000 + product site with 3,000+ categories just when from dead to awesome. Why OC isn't setup this way in the first place? Great extension...thank you, thank you, thank you!
---------------
magzen

Great extension, one of the best i have buyed, website loads extremly fast compared to before
---------------
Hook61

WOW !!
---------------


BONUS Downloads:
These modifications are not part of extension and are not supported.
* BONUS-categories-speedup.ocmod - for OC2+ - alters OC function for fetching categories to use 1 sql. This function is used by some extensions and themes (Journal,...) to build cetegory menus with nested categories. If you have such menu, this modification could speedup your shop.




superdruid_premiumdbindexes_3-1.5.1.ocmod.zip3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2

游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes_3-1.5.ocmod.zip3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes_2-1.4.ocmod.zip2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes-1.2.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes-1.1.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes-1.0.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4

游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes-1.4.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes_2-1.3.ocmod.zip2.0.0.0, 2.0.1.0, 2.0.1.1
游客,如果您要查看本帖隐藏内容请回复

superdruid_premiumdbindexes_2-1.2.ocmod.zip2.0.0.0

游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes_2-1.1.ocmod.zip2.0.0.0
游客,如果您要查看本帖隐藏内容请回复


BONUS-categories-speedup.ocmod2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes_2-1.5.ocmod.zip2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes-1.5.zip1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4
游客,如果您要查看本帖隐藏内容请回复


superdruid_premiumdbindexes_23-1.5.ocmod.zip2.3.0.0, 2.3.0.1, 2.3.0.2
游客,如果您要查看本帖隐藏内容请回复





0

主题

16

帖子

18

积分

新手上路

Rank: 1

积分
18
发表于 2019-3-3 14:05:01 | 显示全部楼层
多谢分享
回复

使用道具 举报

0

主题

30

帖子

38

积分

新手上路

Rank: 1

积分
38
发表于 2019-4-8 10:11:06 | 显示全部楼层
like it very much

0

主题

3

帖子

8

积分

新手上路

Rank: 1

积分
8
发表于 2019-6-4 22:44:38 | 显示全部楼层
opencart数据库加速插件SD Premium DB索引

1

主题

24

帖子

27

积分

新手上路

Rank: 1

积分
27
发表于 2019-7-5 22:04:01 | 显示全部楼层
看看看看看看

0

主题

28

帖子

38

积分

新手上路

Rank: 1

积分
38
发表于 2019-8-4 10:10:49 | 显示全部楼层
好东西饿
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|小黑屋|528站长之家 ( 苏ICP备12019766号-1 )

GMT+8, 2019-9-23 08:32 , Processed in 0.063508 second(s), 34 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表