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-06-2003 11:23 PM

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

Zachery 09-06-2003 11:52 PM

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-06-2003 11:59 PM

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

filburt1 09-07-2003 12: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 01:08 AM

how do u reduce queries?

filburt1 09-07-2003 01:14 AM

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

assassingod 09-07-2003 07:05 AM

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

blakkboy 09-07-2003 02:22 PM

^^^ which hacks would be good for that

assassingod 09-07-2003 02:28 PM

filburts or Xenon's, both are equally good

blakkboy 09-07-2003 04:25 PM

could i get a link :)


All times are GMT. The time now is 03:11 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.01767 seconds
  • Memory Usage 1,720KB
  • 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