vb.org Archive
Page 5 of 6 « First 34 5 6
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   New Posts / Get Daily Optimization (https://vborg.vbsupport.ru/showthread.php?t=66578)

PranK 06-30-2004 06:52 AM
Quote:
Originally Posted by Freddie Bingham
Here is a small 3.0.2 optimization to search.php?do=getnew / search.php?do=getdaily that you can make a noticeable impact on your load.
Awesome - thanks!! :D

Logician 06-30-2004 01:57 PM
This hack is VERY VERY effective for a large board. Check the screenshots for the difference it makes. Thx for sharing it!

Xenon 06-30-2004 03:04 PM
actually i think it's just a bug in the mysql query optimizer.

with the added code it is using the index, without it doesn't use it.
but as there are just the 0,1 as values, the optimizer should always use the index in my eyes.

but i'm sure they might have had an reason for this (or not ;))

Mijae 06-30-2004 03:33 PM
Pretty nice :D 0.02 seconds instead of 0.05 :P

neocorteqz 06-30-2004 03:50 PM
Quote:
Originally Posted by Logician
This hack is VERY VERY effective for a large board. Check the screenshots for the difference it makes. Thx for sharing it!
Damn thats nice.

Oblivion Knight 07-07-2004 11:31 AM
Quote:
Originally Posted by Boofo
Will this work on RC3 for now? Once 3.0.2 gets released, I plan on upgrading (that is if 3.0.3 isn't just around the corner). ;)
That's just scary. You predicted something before it happened.. :paranoid:

*ahem* Sorry for going off-topic.

Polo 07-28-2004 08:56 PM
Cool, this has been added in version 3.0.3 :)

YabbaDabba 08-07-2004 08:13 PM
Get New went from 0.26 to 0.02

Thanks!

**clicks install**

ImportPassion 08-20-2004 01:03 AM
Quote:
Originally Posted by Polo
Cool, this has been added in version 3.0.3 :)
what he said

ImportPassion 08-20-2004 01:04 AM
just answered my own question. and the answer is yes


All times are GMT. The time now is 02:33 PM.
Page 5 of 6 « First 34 5 6
Show 40 post(s) from this thread on one page

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.01033 seconds
  • Memory Usage 1,728KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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