You can view every posts on the forum without registering, but to see the video links you must subscribe : HERE , choose your plan (30days, 90days or more), and register a forum account, with same username and email. We will check and approve your account. There is no automatic renewal. Please note you cannot join with Subyshare Premium key. If the price for a month is not $20, please contact Subyshare's assistance.

How to search by Category?

Hi, POV is probably too short of a word to search in the forum. I'll see if there's a way to allow search engine to search for shorter words. Other than that, categories are primarily made for the shop, which isn't open yet, but when it does, you'll be able to use categories for search more easily then on forum.
 
Please, Log in or Register to view quote content!
I'll discuss with dev about search. I guess since it's the same everywhere, search for words with very few characters must be bad, but technically I don't know why, can you explain ?

Shop will work like it did on previous platforms : once it's up, videos older than 30 days become available only on shop. Search will be better on shop. There will be also packs/bundles like 30 vids of celeb x for a discount price etc...
 
Please, Log in or Register to view quote content!

"Bad" is probably the wrong word.

So your forum obviously consists of your software which is connected to a database. In that database contains every post ever made on here. In order to search through those posts, the forum software tells the database to create an index of every single word used in every single post. This makes searching very fast, every time anyone makes a post then it just adds into the index with all the words it needs to linked to the ID of the post. So if you search for the word "Cock" then the index holds the post IDs of every post that has the word "Cock" in it without having to individually search through every single entry in the database.

Anyway, MySQL which presumably is the database that you run, has a system variable that limits the minimum of characters of a word in the index. This is usually set to 4 because in English, there's lot of small 3 letter words that nobody is going to search for. The, its, for, lot, and others are examples of this. It means that your index will grow because basically every post ever is going to have the word "the" in it and "are" and things like this. So now your index would have grown in size in terms of disk space. It also means that searches will take a very tiny amount of time more (in the millisecond range). This is why the default is 4, its the minimum that the database developers set as a trade off between efficiency and usefulness

Honestly it just doesn't matter for a forum of this size because there isn't going to be any performance issues due to the activity here, the only risk is that someone has to go and mess around with the system settings in the database which can be a problem if they don't know what they're doing.
 
Ok, we'll probably put it back to 4 whenever we open more areas for discussion and when the shop opens. Thanks for explaining.

Check your mail btw.
 
Last edited:
    • -
      The web server timezone is used (Europe/London)
Back
Top