Go Back   vb.org Archive > Search Forums
FAQ Community Calendar Today's Posts Search

Showing results 1 to 5 of 5
Search took 0.01 seconds.
Search: Posts Made By: telescopi
Forum: Big Board Discussions 09-03-2007, 08:12 AM
Replies: 9
Views: 3,251
Posted By telescopi
As the OP says - locking. Sphinx search...

As the OP says - locking.

Sphinx search avoids all locking issues because it is not a part of mysql, it also helps that it is lightning fast - sub 1 second results whewre fulltext would have taken...
Forum: vB3 General Discussions 08-31-2007, 08:08 PM
Replies: 0
Views: 835
Posted By telescopi
post.ipaddress index?

Does anyone know why there's no index on the ipaddress field in the post table?

IP address searches are so slow, surely an index here would be a huge speed up. I know updating the index will be a...
Forum: Forum and Server Management 08-28-2007, 11:55 AM
Replies: 833
Views: 241,231
Posted By telescopi
Works here - I just followed the instructions on...

Works here - I just followed the instructions on obans post on page 26.

Could your vbulletin max results be limiting what sphinx is returning?

What happens if you sort ascending?
Forum: Big Board Discussions 08-27-2007, 04:19 PM
Replies: 9
Views: 3,251
Posted By telescopi
I've spent most of today doing it - going off the...

I've spent most of today doing it - going off the basic idea in orbans thread. I think I've listed every change I made.

The first bit in sphinx.conf is replace pagetext in the two post queries...
Forum: Modification Requests/Questions (Unpaid) 10-15-2001, 07:11 AM
Replies: 3
Views: 1,047
Posted By telescopi
We have a fairly heavily moderated board...

We have a fairly heavily moderated board (forums.overclockers.co.uk), no swearing, no mentioning of competitors etc. but enforcing the rules can sometimes be a little harsh - ie. a ban.

There has...
Showing results 1 to 5 of 5

 
Forum Jump

All times are GMT. The time now is 03:20 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.01223 seconds
  • Memory Usage 1,907KB
  • 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)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (5)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (3)threadbit_pagelink 

Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.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_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • forumjump
  • search_complete
  • navbits
  • navbits_complete