Question Reguarding Queries....

[Gio~Logist]

My php knowledge is still at a below average level, however, a question has come to my mind reguarding php hackers. What is the difference between the hacks that use queries and those that dont? Do they still have the same amount of accuracy and effect? Before i redid my board i had 163 queries. Now i have even more hacks including the ones i had before (but different versions) and i only hadve 42 queries. Why use unnecessary queries in the first place? What's the difference?

[filburt1]

Queries are necessary to retrieve, manipulate, and store information in the database.

Any page that uses a ridiculous number of queries is querying in a loop, which is bad practice.

[Gio~Logist]

oh i see

[Brad]

One way or anthor is not always right. Each situation requires testing to find the best methods of getting the page to load quicker.

As filburt said all queries do is retrive, store, and modify information in your database. Having many queries per page can be bad as you are putting strain on the database.

Ever open multiple large files on your home pc only to have it slow down while the HDD is begin read? Same thing here.

163 is a very high number, so is 43, you'll want to take a look at your forum and figure out exactly what is making all these calls to mySQL. You are probbly running a lot of hacks you don't need, of these hacks many may not be optimized correctly.

At the end of the day you should not base what you install on if it adds an extra query or not. Say you make two queries for similar info, its possible to combine them into one large query. When using 2 queries it takes .1 seconds per query or .2 seconds for both to run. But when combined the large query takes .5 seconds to execute.

In that case using 2 small queries is faster then one large one. In some cases it can be the other way around. So you should always test and figure out the best method for your forum/server.