shit.. this is a memorable day.

With the help of some other vB forum admins/coders (some with boards over 10 million posts) - I've managed to implement a custom search for the new forums that is so fast it's sickening. (You can search all posts in the database in 1 shot again...)

This is important because vBulletin 3.6 is much more server intensive (overall) compared to the version TA is on now. This search development may offset the requirement of upgrading to a new server, but, I doubt it.

First result is posts, next line is threads.

query 'tiesto ': returned 20 matches of 137773 total in 0.439 sec
query 'tiesto ': returned 20 matches of 5179 total in 0.091 sec

query 'trance ': returned 20 matches of 271058 total in 0.386 sec
query 'trance ': returned 20 matches of 13947 total in 0.082 sec

Even stupid searches are relatively fast:

query 'quote ': returned 20 matches of 1629048 total in 2.321 sec
query 'this ': returned 20 matches of 927209 total in 11.137 sec

...anyways, got some more tinkering to do - specifically removing common words ('this', 'that', etc.)

Hopefully I can enable 3 letter searching, gotta see how it affects performance.

___________________

"In a world of illusion you only see what you feel"

niceone

___________________
facebook | blog | scrobbler | setarchive | 20160316
"I believe that's referred to as intelligent drum & bass, which obviously means there's a genre of stupid drum & bass out there" (John Peel)

good deal. I understand that's not implemented yet?

___________________

insignificant cor member alliance

Great job Swamper!

___________________

My Set Archive - MY BLOG

Rockin. Nice work Swamper

___________________

sweet, thanks del.

___________________
People who own my ass: Citric Acid, Boomer187, Tribu, Sand Leaper,
Jackson, venomX, jamie, Renegade, Konjin, Akridrot, Miss Bliss.
Psy-T - Down The Rabbit Hole (400minute long acid set)

quote:

Originally posted by stren good deal. I understand that's not implemented yet?

Well the problem is to take all the features from the standard vb3 look here while keeping part of the old look and having it look familiar.

I'm almost done coding an event forum for any regional area that needs it and then there are some cosmetic changes to the navbars/new post/new reply screens which, to be honest, have horrid defaults in the new version. For example, if you go to view a forum, it jams all the users viewing it at the bottom - if there are 75+ ppl in a forum, it'll be a complete jumbled mess down there - shit like that has to be moved around.

Anyways, you can go there and try a search, if you like, lol.

___________________

"In a world of illusion you only see what you feel"

j00 get a cookie! (a half life 2 one no less!)

___________________

http://www.youtube.com/mezzir

quote:

Originally posted by josh4 please don't keep this color scheme. you're giving out a couple hundred bucks for contests, you should be able to shell out a few to a CSS designer for quick aesthetics work

There will be other skins but this colour scheme will be the default.

___________________

"In a world of illusion you only see what you feel"

quote:

Originally posted by Swamper There will be other skins but this colour scheme will be the default.

this one's the best anyways

___________________

http://www.youtube.com/mezzir

quote:

Originally posted by josh4 we'll be able to choose between several layouts?

dude, you need that spelled out again ?

___________________

insignificant cor member alliance

quote:

Originally posted by josh4 we'll be able to choose between several layouts?

quote:

Originally posted by Swamper There will be other skins but this colour scheme will be the default.