vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Reducing Queries (https://vborg.vbsupport.ru/showthread.php?t=113223)

Impreza04 04-17-2006 10:31 AM
Reducing Queries
 
The following code while working, causes alot of queries..
PHP Code:
$cars = $db->query("SELECT * FROM " . TABLE_PREFIX . "lapsdb_carsets WHERE car_id = {$categorys['carid']} ORDER BY car_id ASC ");
$car_name = $db->fetch_array($cars);
$users = $db->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = {$categorys['submitter']} ORDER BY userid ASC ");
$user_name = $db->fetch_array($users);
$kleur = ($e % 2) ? $class='alt2' : $class='alt1';
$lapsbycat[lap_id] = $categorys['lap_id'];
  $lapsbycat[carid] = $car_name['car_name'];
  $lapsbycat[trackid] = $categorys['trackid'];
$lapsbycat[lap_time] = $categorys['lap_time'];
  $lapsbycat[submitter] = $user_name['username'];
  $lapsbycat[comments] = $categorys['comments']; 
Specifically the $cars and $users queries..
These two match up ID's with a respective name, and displays that instead of the IDs.

However this means that every record creates two queries, 20 records per page means its running 49 Queries per page.

Anyone know how I could potentially reduce the amount?
Help is greatly appreciated


All times are GMT. The time now is 11:03 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.01014 seconds
  • Memory Usage 1,717KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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