Site Issues: Technical
#31
Tech Master
iTrader: (36)

I'm always a big proponent of "search before you ask" in Forums so I searched on searching to find info on small word searches. It looks like in the past, searching for words less than three characters did not function, and that was a limitation of vBulletin 2.0. I know that there was a recent upgrade and looking at the botton of any page shows that RCTech is running on vBulletin v3.0.7... but I am still unable to search for "T4" or "B4". I assume that not being able to search for two character strings, is by design. Being able to do so would probably bog down searches too much.
So, my question is this: are there any vBulletin "tricks" to be able to search using two character search strings? I need more B4/T4 stuff!
Mr.Maim
Thanks again!
So, my question is this: are there any vBulletin "tricks" to be able to search using two character search strings? I need more B4/T4 stuff!

Mr.Maim
Thanks again!

#32
R/C Tech Founder

Thread Starter

There may be a way to do this more easily in the newer vB versions using indexing on the MySQL side rather than the vB side. We are about 2-3 weeks from our big upgrade and I'll take a closer look then to see what I can do.

#33
Tech Master
iTrader: (36)

No problem whatsoever. Ultimately, if the answer is: "it's that way by design"' that's acceptable to me. I do software QA, and the company I'm with has a product that is a front-end for an Access (soon to be MySQL) database. So, I see on a regular basis how much database access, modification, and search can really tax a system. If not being able to search two character strings is not feasable so that words like "in", "is", "ok", or whatever else someone might put in a search string would adversely impact the overall functionality of the Forum's database... so be it. I'd rather have faster overall access than the ability to search for "T4".
Thanks for responding!
Mr.Maim
Thanks for responding!
Mr.Maim

#34
R/C Tech Founder

Thread Starter

Yea, the main reason it did not have that ability, is that the forum keeps an index table of all the words everywhere. So since there are so many small words, it had a character limit and only indexed the words above that limit to save size and space.
The newer versions of the forum use more advanced MySQL features to eliminate the need for this type of indexing.
The newer versions of the forum use more advanced MySQL features to eliminate the need for this type of indexing.

#35
Tech Elite

iTrader: (1)
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)

try adding a meaningless boolean string, like 'T4 AND the' or something like that, because basically every post with the word 'T4 in has the word THE in.'

#36

Has anybody else noticed that the boards seem to be slowing down off and on lately? I'm sure its not my connection because I'm using cable internet and I can surf 2-3 other sites while rctech is still struggling to load one page.
It doesn't seem to be tied to how many people are online either. It could be 250 or 800 people using.
Like I said, its an off and on thing. One minute it could be zipping right along, then the next, you may not be able to even get on the message boards.
Just wondering if anyone else has noticed this.
It doesn't seem to be tied to how many people are online either. It could be 250 or 800 people using.
Like I said, its an off and on thing. One minute it could be zipping right along, then the next, you may not be able to even get on the message boards.
Just wondering if anyone else has noticed this.
Last edited by Darkseid; 04-16-2007 at 09:00 AM.

#38
R/C Tech Founder

Thread Starter

One of the servers in our gateway cluster has been having issues, and just this morning when we power cycled it, a bunch of queued up emails were "released" so to speak, which is why you got some outdated notifications.
The slowdown could be a side effect of this as well. It's an ongoing issue that we're looking into and will hopefully solve in the near future.
The slowdown could be a side effect of this as well. It's an ongoing issue that we're looking into and will hopefully solve in the near future.

#40
Tech Master
iTrader: (36)

Just some stats for you, I've been a server admin for several mid-sized to large corporations so I'm sure you're watching your logs constantly just like I alway do (
NOT! I hate parsing logs looking for errors)... but just in case... there was a slowdown for about an hour this morning, now everything is fine. I figured I post some stats on my end to maybe help narrow down the issue.
Keep up the good work! Again, love the site!
Mr.Maim
=====================Page Refresh Stats======================
All times are GMT -7. It is currently 09:59 AM.
Page Generation: 11.027 seconds [98.74% PHP :: 1.26% MySQL :: 15 Queries]
All times are GMT -7. It is currently 10:09 AM.
Page Generation: 10.502 seconds [99.15% PHP :: 0.85% MySQL :: 15 Queries]
All times are GMT -7. It is currently 10:10 AM.
Page Generation: 11.075 seconds [98.33% PHP :: 1.67% MySQL :: 13 Queries]
All times are GMT -7. It is currently 10:21 AM.
Page Generation: 10.422 seconds [98.98% PHP :: 1.02% MySQL :: 15 Queries]
All times are GMT -7. It is currently 10:28 AM.
Page Generation: 0.979 seconds [57.73% PHP :: 42.27% MySQL :: 13 Queries]

Keep up the good work! Again, love the site!
Mr.Maim
=====================Page Refresh Stats======================
All times are GMT -7. It is currently 09:59 AM.
Page Generation: 11.027 seconds [98.74% PHP :: 1.26% MySQL :: 15 Queries]
All times are GMT -7. It is currently 10:09 AM.
Page Generation: 10.502 seconds [99.15% PHP :: 0.85% MySQL :: 15 Queries]
All times are GMT -7. It is currently 10:10 AM.
Page Generation: 11.075 seconds [98.33% PHP :: 1.67% MySQL :: 13 Queries]
All times are GMT -7. It is currently 10:21 AM.
Page Generation: 10.422 seconds [98.98% PHP :: 1.02% MySQL :: 15 Queries]
All times are GMT -7. It is currently 10:28 AM.
Page Generation: 0.979 seconds [57.73% PHP :: 42.27% MySQL :: 13 Queries]

#42

Everything should be fast and snappy across the board now.
One of the servers in the cluster needed a little work tonight, so if you happened to hit that server you would experience less then stellar speeds. Hopefully tonights upgrades should fix that problem - if not, we'll get it fixed one way or another.
One of the servers in the cluster needed a little work tonight, so if you happened to hit that server you would experience less then stellar speeds. Hopefully tonights upgrades should fix that problem - if not, we'll get it fixed one way or another.


#44
Tech Master
iTrader: (36)

Originally Posted by JasonP
Everything should be fast and snappy across the board now.
One of the servers in the cluster needed a little work tonight, so if you happened to hit that server you would experience less then stellar speeds. Hopefully tonights upgrades should fix that problem - if not, we'll get it fixed one way or another.
One of the servers in the cluster needed a little work tonight, so if you happened to hit that server you would experience less then stellar speeds. Hopefully tonights upgrades should fix that problem - if not, we'll get it fixed one way or another.


#45
Tech Master
iTrader: (36)

Here's something a little "off" that I discovered today: I've been a member for almost a year, and today saw (what I thought to be a new) Forum thread called "Exclusive Nitro Engine Zone". So I told my co-worker about it (nitro guy) and he could not see it. Well, to make a short troubleshooting story short, we discovered that when you are viewing the General Forums category from the root R/C Tech Forums view, there are 14 sub-forums. When you click on the "General Forums" tab, you then see the General Forums sub-view, you will see 18 sub-forums. I checked all of the other sub-forums and they are all published to the root R/C Tech Forums view with the exception of the "North American Regional Forums" which publishes 16 of 18; and "International Forums" which publishes 7 of 9.
I didn't know whether this is by design or not, but I'm wondering if I'm not the only one overlooking the Forums that are not being published to the root R/C Tech Forums index. All the ones that are not published to the main page have noticeably less posts, on average, than surrounding folders.
Mr.Maim
I didn't know whether this is by design or not, but I'm wondering if I'm not the only one overlooking the Forums that are not being published to the root R/C Tech Forums index. All the ones that are not published to the main page have noticeably less posts, on average, than surrounding folders.
Mr.Maim
