vb.org Archive - Improve performance on thread view updating

Page 2 of 5

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)

- - Improve performance on thread view updating (https://vborg.vbsupport.ru/showthread.php?t=78232)

mute	03-22-2005 01:18 PM

This does look very promising, has jelsoft thought about integrating it into the product?

dwh	03-22-2005 01:31 PM

Yes they are.

I haven't had a chance to develop it yet but using the same principle Ibelieve there are a couple of other places this concept can be used.

mute	03-22-2005 01:33 PM

Thats great news. Now if I can only work up the nerve to upgrade to 3.1.0 when it comes out :)

deathemperor

03-23-2005 04:42 PM

Quote:

Originally Posted by Erwin

I may add this to my forum with over 14mil posts... I am always wary of database corruption.

WTF ! YEAH I mean the number, 14mil posts is really far off my hands ! OMG !

detalhe

04-16-2005 08:01 PM

Installed this and got this error after sometime:

PHP Code:


		
			
Database error in vBulletin 3.0.6:

 

Invalid SQL: INSERTINTOthreadviewsaggregate SELECT threadid , COUNT(*)ASviewsFROM threadviews GROUP BY threadid

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERTINTOthreadviewsaggregate SELECT threadid , COUNT(*)ASviews

 

mysql error number: 1064

Will uninstall :disappointed:

dwh	04-16-2005 08:03 PM

Is the lack of spaces only coming from your post or is it in your code as well? And what version of mysql do you have installed?

T3MEDIA

04-16-2005 11:39 PM

good questions.

red_baron2000

04-16-2005 11:49 PM

will certainly give it a go ..:)

detalhe

04-17-2005 09:51 AM

Quote:

Originally Posted by dwh

Is the lack of spaces only coming from your post or is it in your code as well? And what version of mysql do you have installed?

Now that you mention it, I think you should correct your code above, I think that lack of spaces comes from it

PHP Code:


		
			
$DB_site->query("INSERTINTO".TABLE_PREFIX ."threadviewsaggregate SELECT threadid , COUNT(*)ASviewsFROM " . TABLE_PREFIX . "threadviews GROUP BY threadid");

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "threadviews"); 



$DB_site->query(

         "UPDATE " . TABLE_PREFIX . "thread,". TABLE_PREFIX ."threadviewsaggregate 

        SET ". TABLE_PREFIX ."thread.views = ". TABLE_PREFIX ."thread.views + ".TABLE_PREFIX."threadviewsaggregate.views

        WHERE ". TABLE_PREFIX ."thread.threadid = ". TABLE_PREFIX ."threadviewsaggregate.threadid"); 



$DB_site->query("DELETE FROM ". TABLE_PREFIX ."threadviewsaggregate");

Will try it ;)

Dean C

04-19-2005 03:34 PM

Indeed you need to space your query out - that's why it's not working :)

All times are GMT. The time now is 01:46 AM.

Page 2 of 5

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01140 seconds Memory Usage 1,744KB 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 (2)bbcode_php_printable (2)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
Messages: