Νέο Design.

[TriaBita]

mi to skeftese periploka to 0ema,

ena table ftiaxnis me to user_id, forum_id, topic_id kai timestamp to opoio enimerwneis analoga ka0e fora pou enas user episkeptete ena topic.

H anaklhsh meta den einai kai toso dapanifora gia thn DB dedomenou oti exeis ta treia prwta pedia se index kai ta kritiria pou dinis odigoun thn DB karfi sth eggrafh pou se endiaferei.

Praktika auto pou kanis einai na kratas ena timestamp ths teleuteas episkepseos ka0e xristi sta topic pou pige.

Einai oti poio efficient ginete me to ligotero dinato xrono ulopoihshs.


TriaBita

[Wolverine]

mi to skeftese periploka to 0ema,

ena table ftiaxnis me to user_id, forum_id, topic_id kai timestamp to opoio enimerwneis analoga ka0e fora pou enas user episkeptete ena topic.

H anaklhsh meta den einai kai toso dapanifora gia thn DB dedomenou oti exeis ta treia prwta pedia se index kai ta kritiria pou dinis odigoun thn DB karfi sth eggrafh pou se endiaferei.

Praktika auto pou kanis einai na kratas ena timestamp ths teleuteas episkepseos ka0e xristi sta topic pou pige.

Einai oti poio efficient ginete me to ligotero dinato xrono ulopoihshs.


TriaBita

Akoma kai etsi isos einai poly bari meta apo ligo. syn oti etsi xanis ligo kapia topic pou pithanos o xristis den episkeftike kai exoun enimerothei apo thn teleftea fora pou mpike. giafto ipa pos exei na kanei me ton arxiko sxediasmo ths database yparxoun poles ylopoihseis ara xorisd perisotera dedomena den einai toso aplo na pis oti afto tha doulepsi.

[TriaBita]

Akoma kai etsi isos einai poly bari meta apo ligo. syn oti etsi xanis ligo kapia topic pou pithanos o xristis den episkeftike kai exoun enimerothei apo thn teleftea fora pou mpike. giafto ipa pos exei na kanei me ton arxiko sxediasmo ths database yparxoun poles ylopoihseis ara xorisd perisotera dedomena den einai toso aplo na pis oti afto tha doulepsi.

Ta queries pou ektelounte se ka0e page view sto phpnuke kai epipleon sto forum einai idietera 'varia' opos 0es na ta onomazeis. Praktika omos den klanoun mia, kai poso malista se ena site xamilis sxetika kinhshs opos auto. Ean to site eixe na kanei me mia userbase anw twn 500.000 xristwn tote 0a eixe noima na milousame gia 'varia' queries kai optimization.

Auta prokiptoun apo gegonota (antistixa stisimata website me userbases anw twn 100.000 xristwn) kai oxi se ena 0eoritikofilosofiko plaisio.

Gia na sinopsizoume lipon, praktika ena query parapanw to opoio exei ws kritiria 3 apo ta 4 fields enos table (otan zitaei to forum na dei pote eides last ena topic jerei kai ti user_id exeis, kai se poio forum eisai kai ti topic koitas) ta opoia fields einai kai se index,me to zori ginonte antilipta se microseconds.

Oson afora to an 0a doulepsei, den einai kati pou evgala apo to mualo mou. Einai h sinistomenh praktikh gia sites tou eidous kai me0odos thn opoia xrisimopoiw kaigw sto diko mou website kai doulevei mia xara.


TriaBita

[Wolverine]

Afto pou eipa ego einai ti ginete me ta topic pou o xrisths den exei dei pote sto parelthon afta pos tha mpoun sto table kai epita giati na fortoseis yperbolika ton server (analogika me to trafiic tou sigekrimenou site panta) yparxoun kai aloi tropoi h logikh afou doulevi einai entaksi den einai panta h kaliterh. episis prosopika den exo doulepsi me PHP opote den ksero akrivos pos paizei ego to blepo kathara apo apopsi database kai na gini me oso to dinaton ligotero forto.

[chatasos]

Τώρα τελευταία μου βγάζει το παρακάτω όταν κάνω post.

Could not find email template file topic_notify

DEBUG MODE

Line : 139
File : /home/empire1155/www/includes/emailer.php

Υπάρχει κανένα πρόβλημα?

[Gregory]

Μου το βγαζει και μενα και δεν ξερω τι ειναι :? :o