Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 01-07-2010, 02:55 PM
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Location: Canton, MI USA
Posts: 103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Kevlar View Post
vB4 seems unfinished... but then again, most software the comes out these days is far from finished.
Having written my own web apps in PHP (and a few in JS/AJAX), I can agree that just about any software out there is a "work in progress". Especially mine! However, there are some minor but very noticeable quirks in the vB4 interface that should never have gotten past the beta stage. I will say that functionally, the whole package does work...but it's minor interface issues that make using the forum a pain.

One that irks me no end is that if you use Quick Reply, you can't tab once over to a "post" button anymore. When I'm replying to dozens of posts per day, I tend to stick to a keyboard, and I use all of the shortcuts. Having to hop constantly over to a mouse to click one button is a huge oversight IMHO.

Most of what I found are minor quirks like that. Having said that, though, I've already found some usable plugins that replace what I have in my 3.x installations.

Quote:
Originally Posted by eoc_Jason View Post
I dunno what the average size vB forum is... But you would think if you are selling a forum product, you *want* your clients to be successful. If that means they are going to hit a brick wall after a few million posts in their DB, then you are severely limiting your market.
I may have said this earlier, but I do know search appears to be more modular now. IOW, even though Sphinx is not built in, it appears that you can now plug in a module for a search and it would appear in the search engine selector (under "dbsearch") in admincp.

The search files themselves are in a new location, from what I can tell, and there are also new tables in the database for search. So, I know it has been somewhat reworked but, like you say, it's still slow, and...

Quote:
Originally Posted by eoc_Jason View Post
Imagine if Google took 5 minutes to return every search you make? How many people would be googling?
I don't think that search speeds of 5-10 seconds are all that bad--as a long-time forum user (as many of our members are), I have come to expect that over the dozen or so years I've been using online forums. BUT...when vB takes 20, 30, sometimes 40 seconds to retrieve an often-used word in our forum, and there's a tool (called Sphinx) that returns same in 0.4 seconds...what choice would I make? Yep, I'd find any way I could to get Sphinx running.

Beside speed, I've mentioned elsewhere in these forums (even in this thread perhaps?) that I can configure what Sphinx indexes. With MySQL, I'm stuck with whatever is set up in the my.cnf file. I could reconfigure it, but then I'm doing customizations on MySQL for only one application (vB) and possibly hampering the performance of others. With Sphinx, our members are happy simply because they can now search for three-letter terms (where previously, it was four), and I've eliminated a lot of words in the stopwords file so that some common music-based titles can now be searched. I'm actually a bona-fide hero now because members can search for "Who's Next"!

Quote:
Originally Posted by eoc_Jason View Post
FYI, Searchlight base cost is $2,000 USD...
Ummm, no thanks. We'd pay a couple hundred bucks, but for something that costs almost what hosting does for a year, and far more than the vB product itself...? We can't justify that, not on our donation-based (and advertising-free) funding. Might be justifiable for forums that are far busier than ours, but we can barely scrape up enough donations to keep going for a year at a time...

--------------- Added [DATE]1262887000[/DATE] at [TIME]1262887000[/TIME] ---------------

Quote:
Originally Posted by Kevlar View Post
This post gives some insight to what they did to eliminate locking...
http://www.vbulletin.com/forum/entry...nges-in-vB-4-0

You can read it if you want, but basically it allows changing the table from myISAM to InnoDB so it is no longer table locking but row locking instead (if I understand it correctly).
I just read it, and you read it correctly. Although, one thing they overlooked in their description of vB3 is that we had two search choices: built-in vB search, and fulltext. We already had InnoDB table types set up with vB's built-in search, so this is nothing new to us. In fact, it goes back even further when we changed hosts three or four years ago and we hit a brick wall in performance; this was also back when fulltext was not yet an option in vB3.

In a way, it seems vB searching has taken a step backward. *sigh* We're now back to relying on a built-in search.

The main problem is that MySQL just doesn't scale well! Sphinx helps because it bypasses MySQL entirely during the search process. Sphinx isn't that hard to set up, even without root access.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:02 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.12901 seconds
  • Memory Usage 4,055KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (1)bbcode_php
  • (29)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (41)post_thanks_box
  • (41)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (41)post_thanks_postbit_info
  • (41)postbit
  • (41)postbit_onlinestatus
  • (41)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete