vb.org Archive - what exactly is a query

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 :)

assassingod

09-07-2003 08:43 PM

Xenons:
https://vborg.vbsupport.ru/showthrea...threadid=46848

filburt1s:
https://vborg.vbsupport.ru/showthrea...threadid=53455

Frzzy

09-07-2003 08:44 PM

Try this...

https://vborg.vbsupport.ru/search.php?s=

assassingod

09-07-2003 08:54 PM

He should also take a look at the Hacks Database, a new catagory has been added for Board Optimization

SmEdD

09-07-2003 09:14 PM

Quote:

Today at 05:54 PM assassingod said this in Post #13
He should also take a look at the Hacks Database, a new catagory has been added for Board Optimization

Why look when the searchgod is helping ya ;)

All times are GMT. The time now is 11:39 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01125 seconds Memory Usage 1,732KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (14)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
Messages: