1800の投稿にそれぞれ0～4つのラベルを設定しました
1つの投稿に3000のラベルを設定したわけではありません
media.sql と label.sqlを編集してphpMyAdminでimportしました
ラベル自体はlabel.sqlに全部で515登録しました
label.sqlだけインポートした状態だと表示は遅くなりません
media.sqlをインポートすると表示がものすごく遅くなります
media.sqlのtableを空にすると速く表示されます
勘違いじゃないと思います
試してみて
評価
52
翻訳 / 英語
- 2013/12/22 02:23:07に投稿されました
I have established zero to four labels in each of the 1800 articles.
It's not 3000 labels in one article.
I have edited media.sql and label.sql, and imported it to phpMyAdmin.
The label itself is in label.sql and there are 515 registered labels.
With the current status that only the label.sql is important, the display will not slow down.
The display will be really slow if media.sql is imported.
The display will be fast if the table in media.sql is cleared.
I think that it isn't a misunderstanding.
Please test it out.
katikatiさんはこの翻訳を気に入りました
It's not 3000 labels in one article.
I have edited media.sql and label.sql, and imported it to phpMyAdmin.
The label itself is in label.sql and there are 515 registered labels.
With the current status that only the label.sql is important, the display will not slow down.
The display will be really slow if media.sql is imported.
The display will be fast if the table in media.sql is cleared.
I think that it isn't a misunderstanding.
Please test it out.
評価
60
翻訳 / 英語
- 2013/12/22 02:39:55に投稿されました
I gave 0 to 4 labels to each of 1800 postings. It's not that I gave 3000 labels to one posting.
I edited media.sql and label.sql and imported by phpMyAdmin.
I registered total 515 lables in lable.sql. The display speed does not get slow when I import label.sql only. But when I import media.sql, it gets very slow.
And emptying the table in media.sql makes the speed very fast.
I don't think it's my misunderstanding. Try it one, won't you?
I edited media.sql and label.sql and imported by phpMyAdmin.
I registered total 515 lables in lable.sql. The display speed does not get slow when I import label.sql only. But when I import media.sql, it gets very slow.
And emptying the table in media.sql makes the speed very fast.
I don't think it's my misunderstanding. Try it one, won't you?
最期のone → once です