vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Is this page too server intensive? (https://vborg.vbsupport.ru/showthread.php?t=209168)

ludachris 03-22-2009 11:13 PM
Is this page too server intensive?
 
I have a custom vB page on the site that pulls user data and sorts it. I have some stats turned on and this is what shows up for this page:
Quote:
Page generated in 1.15693402 seconds (2.60% PHP - 97.40% MySQL) with 34 queries
Is that going to kill the db? The page loads quickly enough in the beginning.

I made some tweaks to this page a couple weeks ago, mainly adding a few sorting options, and it seems that after I made the page live, it results in the db slowing down until it crashes with too many connections.

TigerC10 03-22-2009 11:50 PM
That is kind of intensive, but it's not terrible. Unless you've got hundreds or thousands of people accessing the page at once, it shouldn't be a problem.

What you might be having a problem with is that you open a connection to the database, but you don't close it. Are you using vBulletin's database functions or are these your own?

Reeve of shinra 03-23-2009 12:07 AM
Maybe you can pull it once a day (via vb cron) and store it in the vb cache?

ragtek 03-23-2009 12:23 AM
Why put them to the vb cache(you mean datastore or?) when they are just needed on one site?
Caching idee is good, but i wouldn't put them to the datastore

ludachris 03-23-2009 12:27 AM
The cron job idea is interesting.

--------------- Added [DATE]1237771673[/DATE] at [TIME]1237771673[/TIME] ---------------

Quote:
Originally Posted by TigerC10 (Post 1774682)
That is kind of intensive, but it's not terrible. Unless you've got hundreds or thousands of people accessing the page at once, it shouldn't be a problem.

What you might be having a problem with is that you open a connection to the database, but you don't close it. Are you using vBulletin's database functions or are these your own?
It's a stand alone page using the suggested method of building a vb page outside of vb. How exactly do you use vb's db functions?

TigerC10 03-23-2009 12:39 AM
A thought occurred to me, are there search spiders on your board? Because if they're on that page, they could be the ones killing your site. Turn off the visibility to unregistered/guest users.

Dismounted 03-23-2009 10:11 AM
Could you show us the queries?

ludachris 03-23-2009 12:47 PM
Sure, here is where I think there could be issues:

Code:
/////// Get total user count //////
  $userscount=$db->query_first("SELECT COUNT(*) AS users
                                    FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield
                                    WHERE userfield.field2=\"West Virginia\" AND userfield.field19!=\"\" AND userfield.field20!=\"\" AND userfield.field9!=\"\" AND userfield.field68!=\"\" AND userfield.field69!=\"\" AND userfield.field71!=\"\" AND userfield.field72!=\"\"
                                    AND user.userid = userfield.userid");

/////// Set up pagination //////
  $numberpages = $userscount['users'] / $perpage;
  $numberpages = ceil($numberpages);

  if (!isset($pagenumber) or ($pagenumber < 1) or ($pagenumber > $numberpages))
    $pagenumber = 1;

    $pos = ($pagenumber-1) * $perpage;


/////// Get all users //////
          $users=$db->query("SELECT *
                          FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield
                          WHERE user.userid = userfield.userid
                          WHERE userfield.field2=\"West Virginia\" AND userfield.field19!=\"\" AND userfield.field20!=\"\" AND userfield.field9!=\"\" AND userfield.field68!=\"\" AND userfield.field69!=\"\" AND userfield.field71!=\"\" AND userfield.field72!=\"\"
                          ORDER BY userfield.field68 DESC
                          LIMIT $pos,$perpage");

  $counter=0;
Is that enough?

--------------- Added [DATE]1237902053[/DATE] at [TIME]1237902053[/TIME] ---------------

Did you need more info than what I posted?


All times are GMT. The time now is 03: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.00933 seconds
  • Memory Usage 1,731KB
  • 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)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete