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:344514"]yes, and god forbid. it's cause there were holes in my database numbering scheme. originally, I had the top set to the mysql random ORDER BY rand() but with 200K+ entries in the database, it could take up to 15 seconds. so I was "smart" and got it down to .001 seconds. by saying "database what is the max number in the database" then I would randomly select a number between 0 and that max number. since there are holes in my databases, I would select the index one higher than this randomly selected number. problem: if there are holes... like there are before the catch22 picture, the angela rose picture, a god forbid picture and more, then there would be up to a 1300x chance that that picture would be selected. soooo.. what I did was rethink the database in regards to caching. so I went with the SQL command of selecting the entire pictures database. (this should always be cached anyhow). so what I do now is select all pictures in the database find the max picture index randomly select a picture from 0 to the max index number and then use the random number to index off the collection of all the pictures in the database. this runs around .2 second not bad, better than 15 seconds and better than the catch 22 picture showing up over and over.[/QUOTE]
UBB
enabled
. HTML
disabled
Spam Filtering
enabled
Icons: (click image to insert)
Show All
-
pop
[
default homepage
]
[
print
][
2:01:18pm Apr 28,2024
load time 0.01153 secs/10 queries]
[
search
]
[
refresh page
]