Nest

Optymalizacja MyBB - dyskusja

Założony przez mccn.

Online Today (1.1)
Shows you who has been online in the last 24 Hours
Autor Samuel
Nasuwa mi się jeden wniosek - jak koleś piszę coś do mybb (seo) to nie można go winić, że nie współgra to z GoogleSeo (oddzielna wtyka).

http://www.mybbcentral.com/thread-1659.html
Może warto zainwestować? Patrz jak u mnei na forum smiga:
http://www.elfbot.pl/ napisał(a):Użytkownicy: 123, Goście: 181, Boty: 3, Niewidoczni: 4
Victor, Seratex, texas81, lajciak, maslaczyna, Sadmira, Sqawel93, Gtv, Lunatic, dechalol, kaymanowiec, Arcik, Kamilqq93, yogi9322, asesino, bialy06, bialyy1*, Nyklu, akonomek, coller qlimax, Zax999, andoro, Kulba, banan1993, login100100, Aryyt, Coke, danabur, Jooka, Adam147852369, froglem95, Altaris, Gader, kibic1993, dansa, kakarotto13*, rafi8*, szulgo, atom114, maciejus000, etemerion, anonim127*, twardy1908, morfina123, brateq2, ZeD666, Speedo, Lisko, Wibbo, Scigii, anyway, karas001, patol, Devis, keny5551, kraviol, Atrone, Eureka, Sygus, epi, Enigiede, fantomus, KaczoreQ, mucha, Dantello, axel69, samnisty, Ahazin, Szakalaka, KoKuciK, pietru11, mirni, drammatic, krazsky, niewolnica diablica, Zenk, andrzejjanis, czerwonamamba, siwy696, fazik, s0wka, adinek22, Winiak, zwk231, Valsey, Horbi, tytrydsdf, Szczurix, Szakalaka, Betur, lajciak, pulpi, Guci0, andrzejjanis, Draqsters, Mentoll, elana, Tomston11, virus, Gohuus, Soja, Botter, Belliar, gohakus, endoc, polbi, wisienka013, Napster, halucyn, psychopader, moczykij, andoro, Roni93, vixus, Dakon, long3rsky, Smalczyk, lolia, Xavaris
Szczerze mówiąc nie jest mi to jakoś do szczęścia potrzebne, ani to do seo ani jakoś specjalnie pomaga...
Kilka szczegółów o moim forum:
wersja skryptu MyBB:1,4

Mam dziwnie wiele zapytań do bazy mysql per user.


Generated in 0.1026151 seconds (88.04% PHP / 11.96% MySQL)
SQL Queries: 65 / Global Parsing Time: 0.0280960 / Memory Usage: 4.5 MB
PHP version: 5.2.6-1+lenny4 / Server Load: 0.27 / GZip Compression: Enabled

Oto spis moich wtyczek:
Ads after first post (2.2)
Easy Refer (2.0)
Forum stats in profile (2.0)
Hide Links to Guests (1.0)
Image Resizer & Optimizer with GD (1.1)
NoCode (1.0)
SpiceFuse Shoutbox (1.1 Beta 1)
Spoiler MyCode (1.1)
Usermap (1.1)
Username Style (1.0.4)
Warned (1.0)

Dziwne jest jeszcze to, że pare miesięcy temu, forum krzaczyło błąd o barku pamięci przy 40 użytkownikach online. (1GB na 40 osób?)
Wyłączyłem cache w bazie (wcześniej było) jakiejś zmiany nie zauważyłem. No i niestety musiałem dokupić drugą kość pamięci. (w sumie mam 2GB, przy 60 userach online wykorzystanie pamięci jest na poziomie 1200MB).
Sprawdź jakie zapytania wykonuje skrypt np. na stronie głównej. I zobacz co najbardziej obciąża. Jakie masz ustawienia cache? Myślę, że shoutbox może trochę zarzynać bazę.
Cache-files


Oto lista tych 65 zapytań do bazy
#1 - Write Query
SET NAMES 'utf8'
Query Time: 8.39233398438E-5

#2 - Select Query
SELECT * FROM mybb_sessions WHERE sid='7bd137' AND ip='55555' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY PRIMARY 98 const 1
Query Time: 0.000696897506714

#3 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
u const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 4 const 1
Query Time: 0.000535011291504

#4 - Write Query
UPDATE mybb_sessions SET uid='1', time='1261778867', location='/index.php?debug=1', useragent='Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3', location1='0', location2='0', nopermission='0' WHERE sid='7bd137b8f1e6d7236fb67d63c967add1' LIMIT 1
Query Time: 0.000364065170288

#5 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='9' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 0.000128030776978

#6 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','8') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1933 Using where; Using filesort
Query Time: 0.000211000442505

#7 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1261777967' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 51 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 c0bw.s.uid 1
Query Time: 0.000962972640991

#8 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
table type possible_keys key key_len ref rows Extra
f ALL 57 Using where; Using filesort
fr eq_ref fid fid 8 c0bw.f.fid,const 1
Query Time: 0.000243902206421

(Plugin Hook: build_forumbits_forum)
#9 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.000663995742798

(Plugin Hook: build_forumbits_forum)
#10 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000193119049072

(Plugin Hook: build_forumbits_forum)
#11 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '20128'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000191926956177

(Plugin Hook: build_forumbits_forum)
#12 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000195980072021

(Plugin Hook: build_forumbits_forum)
#13 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.58171081543E-5

(Plugin Hook: build_forumbits_forum)
#14 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.48634338379E-5

(Plugin Hook: build_forumbits_forum)
#15 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.000730037689209

(Plugin Hook: build_forumbits_forum)
#16 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '36616'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000204086303711

(Plugin Hook: build_forumbits_forum)
#17 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '7688'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000195026397705

(Plugin Hook: build_forumbits_forum)
#18 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '36023'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000198841094971

(Plugin Hook: build_forumbits_forum)
#19 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '28846'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000223875045776

(Plugin Hook: build_forumbits_forum)
#20 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '34424'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000175952911377

(Plugin Hook: build_forumbits_forum)
#21 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 9.08374786377E-5

(Plugin Hook: build_forumbits_forum)
#22 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '38813'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000247001647949

(Plugin Hook: build_forumbits_forum)
#23 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.60555267334E-5

(Plugin Hook: build_forumbits_forum)
#24 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '29731'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000216007232666

(Plugin Hook: build_forumbits_forum)
#25 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '38070'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000274896621704

(Plugin Hook: build_forumbits_forum)
#26 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1470'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00019097328186

(Plugin Hook: build_forumbits_forum)
#27 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '36980'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000196218490601

(Plugin Hook: build_forumbits_forum)
#28 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1470'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 6.38961791992E-5

(Plugin Hook: build_forumbits_forum)
#29 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '12243'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000186204910278

(Plugin Hook: build_forumbits_forum)
#30 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '35290'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000174045562744

(Plugin Hook: build_forumbits_forum)
#31 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '38501'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000735998153687

(Plugin Hook: build_forumbits_forum)
#32 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '815'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000195980072021

(Plugin Hook: build_forumbits_forum)
#33 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.20024108887E-5

(Plugin Hook: build_forumbits_forum)
#34 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '5936'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000182867050171

(Plugin Hook: build_forumbits_forum)
#35 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '38632'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000149965286255

(Plugin Hook: build_forumbits_forum)
#36 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '3830'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000169992446899

(Plugin Hook: build_forumbits_forum)
#37 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 9.08374786377E-5

(Plugin Hook: build_forumbits_forum)
#38 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 9.89437103271E-5

(Plugin Hook: build_forumbits_forum)
#39 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '38716'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000190019607544

(Plugin Hook: build_forumbits_forum)
#40 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '542'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000221014022827

(Plugin Hook: build_forumbits_forum)
#41 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8.98838043213E-5

(Plugin Hook: build_forumbits_forum)
#42 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '321'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000268220901489

(Plugin Hook: build_forumbits_forum)
#43 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8.01086425781E-5

(Plugin Hook: build_forumbits_forum)
#44 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.79628753662E-5

(Plugin Hook: build_forumbits_forum)
#45 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '28446'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000197887420654

(Plugin Hook: build_forumbits_forum)
#46 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 6.79492950439E-5

(Plugin Hook: build_forumbits_forum)
#47 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '33385'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.000239133834839

(Plugin Hook: build_forumbits_forum)
#48 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '36769'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000174045562744

(Plugin Hook: build_forumbits_forum)
#49 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '30629'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000303030014038

(Plugin Hook: build_forumbits_forum)
#50 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.79628753662E-5

(Plugin Hook: build_forumbits_forum)
#51 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '29801'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000232934951782

(Plugin Hook: build_forumbits_forum)
#52 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 9.01222229004E-5

(Plugin Hook: build_forumbits_forum)
#53 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8.01086425781E-5

(Plugin Hook: build_forumbits_forum)
#54 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '36980'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8.79764556885E-5

(Plugin Hook: build_forumbits_forum)
#55 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 8.9168548584E-5

(Plugin Hook: build_forumbits_forum)
#56 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.89165496826E-5

(Plugin Hook: build_forumbits_forum)
#57 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1447'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00019907951355

(Plugin Hook: build_forumbits_forum)
#58 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.70092010498E-5

(Plugin Hook: build_forumbits_forum)
#59 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000108957290649

(Plugin Hook: build_forumbits_forum)
#60 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10658'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000204086303711

(Plugin Hook: build_forumbits_forum)
#61 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10720'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.48634338379E-5

(Plugin Hook: build_forumbits_forum)
#62 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 8.39233398438E-5

(Plugin Hook: build_forumbits_forum)
#63 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000781059265137

(Plugin Hook: build_forumbits_forum)
#64 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '542'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7.91549682617E-5

(Plugin Hook: build_forumbits_forum)
#65 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 9.79900360107E-5
Wtyczka "Username Style" wygląda na katastrofalnie napisaną. Sprawdź, jak będzie wyglądać sytuacja po jej wyłączeniu.
Wyłączona i spadło do 8 zapytań.

BTW. Macie może jakąś podobną wtyczkę?
Ostatnio szperałem sobie w MyBB, co by tu zmienić aby szybciej forum śmigało. Doszedłem do wniosku, że za dużo z tym zabawy, ale zamiast css wbudowanego w MyBB(odnosi się do css.php, to wykonuje miliony zapytań do bazy o arkusz stylu... szablon headerinclude zmienna {$stylesheets}) dam statyczny plik css.
Przekopiowałem więc wszystkie css(a np. w stronie z tematem ładuje 4 arkusze stylu!!!!!) do jednego statycznego pliku i skompresowałem.
Oto wyniki.
[Obrazek: ff5zx4.png]
Zwróccie uwagę na koniec wykresu, to mniej więcej okres zmiany arkuszy. I z każdym dniem ta linia idzie w górę. Jak widać jednak względem wydajności, sporo MyBB brakuje, a wystarczy tak nie wiele aby usprawnić wczytywania forum.
A forum samo w sobie naprawdę dostało kopa od tak prostego zabiegu, strony wczytują się ok 40 % szybciej. ;-)
DamYan napisał 20.02.2010, 17:10:
Przenoszę do dyskusji o optymalizacji.
Co widać na tym wykresie? Bo ja nic nie widzę :)
Poprawione, chodziło mi o koniec wykresu.
(20.02.2010, 15:31)wujas napisał(a): Poprawione, chodziło mi o koniec wykresu.

Tylko nadal nie wiadomo, co on przedstawia. Na osiach nie ma nic. Dodatkowo ten czerwony poziom - co oznacza? :)
To wyciąg z google webmasters. Dodałem poprawiony ss z resztą.
A czerwona linia, to chyba taka "wartość krytyczna". ;)
Skorzystaj z dodatku dla Firefoxa Firebug, tam sprawdzisz nawet wczytywanie pojedynczego pliku na forum, np, który się najdłużej wczytuje, program znajduje tez błędy javascript
Ni potrzebuje, wystarczy mi debug=1 aby wiedzieć co w trafie piszczy i nie proszę tutaj o rade a jedynie chce pokazać że nawet głupie css potrafi odmulić stronę. ;-)
Wykres już konkretnie poszedł w górę, na dniach przetestuje jeszcze wyniki z xcache i jakoś ładnie podam. ;)

Podobne wątki

LastPosterAvatarLight - dyskusja o pluginie

13.10.2016, 19:40
Ostatni post: NiespecjalnieUzdolniony

MyBB 1.6 - dyskusja

03.08.2010, 09:02
Ostatni post: ZirakS

Skocz do:

Użytkownicy przeglądający ten wątek:

1 gości