Dedecms-Table Tutorial

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Many friends who use Dede to make Web sites will encounter data that is too large, this causes the generation of HTML slow to open the column list slow and so on, the author according to the Dream forum some posts summed up the default article model transfer data to other new models of a simple tutorial, now share out, master can be ignored.

It is strongly recommended that you back up the database before you do the following:!!! I am not responsible for the loss or any errors. I successfully transfer using the following methods.

Homepage set up a new model-system model-new field-content (body) HTML text solidify fields.

Now set the relevant description of the demo, the original model is the article model, channel=1, additional table for dede_addonarticle, new Model X, channel=19, additional table for dede_addon19; original column typeid=300 New column with x content model typeid=400

Let's move on, phpMyAdmin, or dream. Run the following command with the SQL command-line tool, specifically: because the new model and the original normal article model primary key will not be able to insert data, prompt error: #1062-duplicate entry ' 343 ' for key ' PRIMARY ', so to modify the phpMyAdmin in the New Model attached table DEDE_ADDON19 primary key aid data type is bigint, the specific method can be Baidu.

We continue, enter:

INSERT INTO dede_addon19 select * dede_addonarticle where typeid=300;

The above SQL means to select the contents of Dede_addonarticle (that is, ordinary articles) to insert into the new dede_addon19 (that is, the X model).

Run again, enter:

Update dede_archives set channel =replace (channel, ' 1 ', ') where typeid=300;

It means to change the channel of the data of the Dede_archives Main table column to 300 from 1 to 19;

Run again, enter:

Update dede_archives set typeID =replace (typeID, ', ') where channel=19

Similarly, the data column of channel 19 was changed from 300 to 400;

OK, article path what all set up, update the column cache, generate column list and content, OK!

This method is applicable to a large number of dede_addonarticle6184.html "> data table segmentation, such as your data sheet has been more than 500M, it is imperative."

Not perfect: The Dede_archives master table is not separated. Hope the master can be supplemented.

This article by the "Job Search service Network"-www.cnhro.com original starting, reproduced please specify, I reserve the right to pursue responsibility!