|
New site? Maybe some day.
|
I'm going to fight you for disabling the search option. |
|
yeah...I actually used that quite a few times |
|
this is what I get:
Sorry, discussion search is disabled for now.
it's killing the server. |
|
I think stupid people do more damage to the server than searching. |
|
Keith, you should know by now there's too many stupid people to do anything about them. |
|
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. |
|
NOW HOW WILL WE FIND CARINA'S BOOBS!?!?!?!?!?!?!?!?!?!!?! |
|
here you go:
|
|
Those boobs are almost as big as my ego. |
|
still looking into this one. |
|
is that montreal in the background? |
|
this is still bothering me.. |
|
BSV@school said: is that montreal in the background? |
The massive amount of smog in the background didn't give it away?
|
|
good god, that is a lot of smog |
|
it's like carina is smirking at me.. virtially. |
|
sort of like your mona lisa? |
|
wait, no...that's not you dressed in drag |
|
I have a couple ideas.. but I don't want to do it the way I might have to do. |
[default homepage]
|
[print][ | 2:35:58am Apr 29,2024 load time 0.01881 secs/15 queries] | [search] | [refresh page] |
|