Hongmu Notes
Home Program Notes pbootcms moves content fields to secondary tables (improves website speed)
Program Notes PbootCms

pbootcms moves content fields to secondary tables (improves website speed)

pbootcms moves content fields to secondary tables (improves website speed)

It's not actually moving!

First, create a model field:

20231208125351284-图片

Migrate SQL content fields to Ext content fields:

 隐藏内容:评论后查看
INSERT INTO ay_content_ext (contentid, ext_contents)
SELECT id, content
FROM ay_content;
UPDATE "main"."ay_content" SET "content" = '';
UPDATE "main"."ay_content" SET "description" = '' ;

SQL statements can be used with both SQLite and MySQL – they work equally well!

Open MySQL directly via its web interface and execute SQL queries.

Download SQLite directly to your computer and open it using a database management tool, such as Navicat Premium 12 (after successful execution, you will need to upload and overwrite the existing database file!).

Once you've completed these steps, simply replace the content fields in the template!

Next, you'll notice a significant improvement in your website's loading speed!

微信赞赏

WeChat

支付宝赞赏

Alipay

✍️ Author: Hong Mu

webmaster · Thanks for reading, stay tuned for more exciting content

Author homepage View home page →

Related articles

Addition of message function to pbootcms website

Addition of message function to pbootcms website Program Notes PbootCms

Scope of application of message board tags: can be used anywhere on the entire site Tag function: used for users to submit messages and retrieve message records 1. Message submission form<form action="{pboot:msgaction}" method="post"> Contact person:<input type="tex…
👁 174
pbootcms introduces public file code

pbootcms introduces public file code Program Notes PbootCms

1. Template file nested reference {include file=***.html} Instructions for use: It can be used nested, such as: index.html nests a head.html, and nested comm.html in head.html supports the use of subdirectories, such as: {include file=comm/*.html} 2. Time formatting tag style=*, such as: within...
👁 235

Recommended reading

Python reported an error. What is the reason? AttributeError: partially initialized module ' openai'  has no attribute ' Completion' (most likely due to a circular import)

Python reported an error. What is the reason? AttributeError: partially initialized module ' openai' has no attribute ' Completion' (most likely due to a circular import) Language Notes python

This error prompt indicates that there is a problem when importing the openai module and the specific Completion attribute, which is probably caused by circular import. The reason for this error may be that two or more modules in your code are imported from each other, forming a circular dependency. For example, module A imports module B, and module B imports module A.. Cyclic import will cause the module not to initialize correctly when loading, thus …
👁 656
(PC+WAP) Marketing-oriented plastic sheet purification and environmental protection equipment website – pbootCMS template; Green and eco-friendly hardware sheet website template download – 0691

(PC+WAP) Marketing-oriented plastic sheet purification and environmental protection equipment website – pbootCMS template; Green and eco-friendly hardware sheet website template download – 0691 Practical Collection pbootcms Template

A PbootCMS marketing template designed for the plastic sheet, environmental protection equipment, and hardware sheet industries, featuring a green-themed design and supporting both PC and WAP devices. The page layout focuses on product showcasing and environmental sustainability messaging, helping companies specializing in eco-friendly materials build a green brand image online and attract targeted customers. Template Display | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www...
👁 50
Responsive entrepreneurial news website template 0792

Responsive entrepreneurial news website template 0792 Practical Collection Yiyou template

This eyouCMS responsive template is ideal for startup-related information and news websites. Its design features a startup information feed that aggregates startup updates, investment news, business models, and success stories, helping entrepreneurial media outlets attract both entrepreneurs and investors online. Template Display | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for EyouCMS | EyouCMS (Ey...
👁 61
(PC + WAP) Eco-friendly & Energy-Saving Research-Based PbootCMS Website Template – Download Blue Eco-Friendly Corporate Website Source Code (0067)

(PC + WAP) Eco-friendly & Energy-Saving Research-Based PbootCMS Website Template – Download Blue Eco-Friendly Corporate Website Source Code (0067) Practical Collection pbootcms Template

This PbootCMS template features a blue color scheme and is specifically designed for environmental protection and energy-saving organizations as well as research institutions; it supports both PC and WAP devices. The page design is professional and meticulous, making it ideal for showcasing environmental technologies, research achievements, and project cases. It helps environmental research institutes or energy-saving enterprises establish an authoritative online brand image and seize more collaboration opportunities. Template Display | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin...
👁 44
Responsive Training Platform – Educational Software Website Template 0149

Responsive Training Platform – Educational Software Website Template 0149 Practical Collection Yiyou template

This EyouCMS responsive template is ideal for training platform and educational software companies. Its educational technology-oriented design is perfect for showcasing online training platforms, teaching software, course resources, and technical solutions. It helps education technology firms present their brand online and attract both school and corporate clients. Template Overview | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Common Questions About EyouCMS Installation...
👁 44
(Adaptive mobile version) Responsive SEO-optimized website template for interior decoration and renovation companies – PBootCMS; Download SEO-optimized source code for interior decoration and renovation projects – 0692

(Adaptive mobile version) Responsive SEO-optimized website template for interior decoration and renovation companies – PBootCMS; Download SEO-optimized source code for interior decoration and renovation projects – 0692 Practical Collection pbootcms Template

A responsive PbootCMS website template designed for SEO-optimized and interior decoration companies, compatible with both PC and WAP devices. Its professional, modern design is ideal for real estate and renovation firms to showcase their SEO services and design projects. This template helps decoration businesses conduct online brand promotion and customer acquisition. Template Preview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www.4s5.c...
👁 68