vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   what exactly is a query (https://vborg.vbsupport.ru/showthread.php?t=56825)

blakkboy 09-07-2003 12:23 AM

what exactly is a query
 
what is it and how does it effect the board???

Zachery 09-07-2003 12:52 AM

uhh ill try my best :\

a querry is when php looks for some specific info in the database

i think

and depending on what the querry does is how it would affect the board, if there are too many large querrys it will make the computer work harder

blakkboy 09-07-2003 12:59 AM

so the less query's there are the faster the board will load???

filburt1 09-07-2003 01:30 AM

A query is a request sent to the database that optionally returns data in the form of a matrix (2D array or rows of columns).

The more queries, the more communication there is between the MySQL server and the client (not necessarily PHP), the higher the server load becomes, and the slower the page loads.

MuSuL 09-07-2003 02:08 AM

how do u reduce queries?

filburt1 09-07-2003 02:14 AM

Don't hack vB, or don't query the database unless you absolutely have to.

assassingod 09-07-2003 08:05 AM

Also, you can reduce queries by some of the board optimization hacks

blakkboy 09-07-2003 03:22 PM

^^^ which hacks would be good for that

assassingod 09-07-2003 03:28 PM

filburts or Xenon's, both are equally good

blakkboy 09-07-2003 05:25 PM

could i get a link :)


All times are GMT. The time now is 10:49 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.00987 seconds
  • Memory Usage 1,721KB
  • 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)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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