vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   (real) Archiv for vBulletin 3 (https://vborg.vbsupport.ru/showthread.php?t=66239)

Xenon 08-07-2004 12:10 PM

hmm, i don't know the speed of mysql's full text seraching indexing, but i think so, as it should be strongly optimized ;)

but generally yes, it should be much faster when you are using mysqls fulltext indexing instead of vb's

scotty 01-10-2005 08:33 PM

short note: I've just finished archiving about 2.600.000 postings in my board. I'll have to make some further compatibility test, than I will release it as hack.
it's another approach, then used by Xenon, and the result is a dramatic increase of speed by reducing the "post"-table by half... :)
...so the "key feature" of my hack is speed improvment for large boards (> 1 million posts), and not to reduce used space.

I hope, I get the beta released in about 2 weeks!

scotty

Brains 01-19-2005 03:10 AM

Very interesting to me indeed. I'm only at 2.1 million posts, but we keep them *all* online and searchable at all times. I've since moved search to an alternate slave mysql server to keep from killing site performance, and I'm sure this would help all that much more.


All times are GMT. The time now is 03:54 PM.

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.01016 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete