Share DEDECMS experience in establishing model and table operation

2004, just built the station, I used to http://www.aliyun.com/zixun/aggregation/16485.html ">dede2.0, that time because I do not understand PHP, do not go on."

Later in the DEDE3.1 used him, feeling good, but because he and DZ mixed degree is not high, so gave up. Switched to Sup+dz mode.

Because of the passage of time, found that SUP official basically stopped SUP development, plus, SUP has its own problems, simply gave up the use of SUP, although Baidu included a good tens of thousands of pages, but also without hesitation to change the dedecms.

At present my station (http://www.yyws8.com) is my idea for a long time, has basically formed, but changed Dede after found Dede also have the problem.

This problem is not strange Dede, can only blame me, my column 3000, database will nearly 1g,25 million articles.

The section page can also endure, basically speed also can, but a generation document page is a problem, the reaction speed is extremely slow, produce HTML extremely slow, 201 group produces once to 3-5 minutes, this speed cannot live. And the most deadly is the server is always CPU explosion 100%, too depressed.

DEDECMS5.3 out after also no improvement, listen to others say Dedecms list mode is fetal trouble, very slow, the amount of data once more than 200,000, you must be divided into tables.

I started the difficult learning process. After some good people's advice, finally let me learn this method, now I have the data table storage, speed brush, hehe.

Now share with you.

First of all, to establish a model, the method of building a model lonely Tianya has written a special tutorial, but to note that the model to create a new field, the name is: the text, the English name is: Body, to select the HTML text storage mode. Fixed publishing mode. So you can see more than two 6184.html "> datasheet, one is dede_archivesxx, one is dede_addonxx, you can name yourself." Our main operation is on both tables.

Then start our main operation: Background system Management-System account Management-sql command run