Home
News
Events
Bands
Labels
Venues
Pics
MP3s
Radio Show
Reviews
Releases
Buy$tuff
Forum
Classifieds
News
Localband
Shows
Show Pics
Polls
OT Threads
Other News
Movies
VideoGames
Videos
TV
Sports
Gear
/r/
Food
New Thread
New Poll
Miscellaneous
Links
E-mail
Search
login
New site? Maybe some day.
Username:
SPAM Filter:
re-type this
(values are 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E, or F)
Select Color
orange
orange-red
crimson
red
firebrick
dark red
green
limegreen
teal
silver
sea-green
deeppink
tomato
coral
purple
indigo
burlywood
sandy brown
sienna
chocolate
FONT
XXSmall
XSmall
Small
Medium
Large
XL
XXL
:DG:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Char
†
‡
‰
♠
♣
♥
♦
‾
←
↑
→
↓
™
–
—
¡
¢
£
¤
¥
¦
§
¨
©
ª
«
¬
®
¯
°
±
²
³
´
µ
¶
·
¸
¹
º
»
¼
½
¾
¿
À
Á
Â
Ã
Ä
Å
Æ
Ç
È
É
Ê
Ë
Ì
Í
Î
Ï
Ð
Ñ
Ò
Ó
Ô
Õ
Ö
×
Ø
Ù
Ú
Û
Ü
Ý
Þ
ß
à
á
â
ã
ä
å
æ
ç
è
é
ê
ë
ì
í
î
ï
ð
ñ
ò
ó
ô
õ
ö
÷
ø
ù
ú
û
ü
ý
þ
ÿ
b
i
u
add:
url
image
video
(
?
)
Message:
you are ab-using [QUOTE]blah blah blah[/QUOTE] to reply to the_reverend.
Please remove excess text as not to re-post tons
[QUOTE="the_reverend:370135"]well.. here's the issue. so I have 2 tables that the discussion board is using. one for the subject and stats. the other for the messagebody, time, and who posted it. when you search, you need to search through the messagebody, but it's got to merge the subject table (one entry for each thread) with the messagebody table (one entry for each post). this locks both tables while it's merging them and then returning the result. now, what I have to do is create a cached table (about 100MB) that is merged and then rebuild it every 15 minutes or 20 posts or something. I just need to figure out how to do this in SQL cache space. OR remove table locking. MySQL is suppose to only do row locking so this is really annoying. the band's page was doing the same exact thing, but I build my own caching schema that won't work for the discussion board... I'm going to go ask for some professional direction on this one. I want to do it like phpBB does it.[/QUOTE]
UBB
enabled
. HTML
disabled
Spam Filtering
enabled
Icons: (click image to insert)
Show All
-
pop
[
default homepage
]
[
print
][
4:31:33pm Jun 04,2024
load time 0.00609 secs/10 queries]
[
search
]
[
refresh page
]