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

Showing results 1 to 8 of 8
Search took 0.00 seconds.
Search: Posts Made By: MattR
Forum: vBulletin 2.x Full Releases 06-22-2002, 12:39 PM
Replies: 98
Views: 16,324
Posted By MattR
Won't the count/update of my_threadviews cause...

Won't the count/update of my_threadviews cause almost as much locking problems as the current thread table?

I would say simply keep inserting a threadID into the table, then have the job update...
Forum: vB3 General Discussions 06-05-2002, 01:59 PM
Replies: 34
Views: 5,233
Posted By MattR
Find out what the I/O cost is and you'll have...

Find out what the I/O cost is and you'll have your answer. Query time is not a good indicator of total cost.

http://www.sitepointforums.com/showthread.php?s=&threadid=62319
Forum: vB3 General Discussions 05-26-2002, 02:57 PM
Replies: 34
Views: 5,233
Posted By MattR
I think I suggested something like that on the vB...

I think I suggested something like that on the vB Dev forum. At least with Sybase it is significantly faster than the 3 queries and with less I/O.
Forum: vB3 General Discussions 05-26-2002, 01:46 AM
Replies: 34
Views: 5,233
Posted By MattR
You can tie the 3 PM queries into one if you're...

You can tie the 3 PM queries into one if you're good. :D
Forum: Community Lounge 05-26-2002, 01:43 AM
Replies: 35
Views: 2,936
Posted By MattR
Dude, totally not cool.

Dude, totally not cool.
Forum: Community Lounge 10-31-2001, 03:17 PM
Replies: 16
Views: 3,239
Posted By MattR
Junior member? Awww.. Not that I worry about...

Junior member? Awww.. Not that I worry about post counts but... :(

(double-tap on colored smilies)
Forum: Community Lounge 10-30-2001, 08:30 PM
Replies: 16
Views: 3,239
Posted By MattR
w0rd. I dig the scheme!

w0rd. I dig the scheme!
Forum: Modification Requests/Questions (Unpaid) 07-20-2001, 05:33 PM
Replies: 46
Views: 9,445
Posted By MattR
Would you have to enter annother column? I would...

Would you have to enter annother column? I would think something like this:

every time a page is requested:


SELECT count( * ) AS number
FROM session
WHERE userid = $bbuserinfo[userid]
...
Showing results 1 to 8 of 8

 
Forum Jump

All times are GMT. The time now is 06:18 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.01538 seconds
  • Memory Usage 1,919KB
  • 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
  • (8)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (22)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