PDA

View Full Version : what exactly is a query


blakkboy
09-07-2003, 12:23 AM
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/showthread.php?s=&threadid=46848

filburt1s:
https://vborg.vbsupport.ru/showthread.php?s=&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
Today at 05:54 PM assassingod said this in Post #13 (https://vborg.vbsupport.ru/showthread.php?postid=432082#post432082)
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 ;)