Querys Per hack

[lasto]

I used to install hacks just for the fun of it and never bothered how many queries it made but lately ive gone the opposite way so i can have a faster board with the minimum of connections.

What i would like to see in Hack threads is a seperate box so Hack makers can input how many queries each hack uses.

[Lizard King]

Exactly number of queries are not that important. What is important is the query that is used by the hack. If the query is well written it will have pretty less effect on your board. However if the query is not well written and it has a full table scan it can bring down your server to its knee.

[Paul M]

^^^

What he said - the number on it's own is not as important as what they actually do.

[lasto]

so having a hack that puts 11 querys on your board is fine ?

[Lizard King]

Originally Posted by lasto

so having a hack that puts 11 querys on your board is fine ?

If it is just on one page 11 queries i'll never install that. But again instead of the number you shall check query execution time , used memory by each query etc.. If you give the name of the hack we may comment better

[lasto]

Originally Posted by Lizard King

If it is just on one page 11 queries i'll never install that. But again instead of the number you shall check query execution time , used memory by each query etc.. If you give the name of the hack we may comment better

cant really name the hacks in question but have found 2 on here over last few days

1 adds 10 and the other adds 11 - i was under the understanding that the more queries it makes to the database the slower the board will be.So with these 2 hacks alone that is 21 queries and both are popular hacks.

Cheers for reply as well.

[Paul M]

Originally Posted by lasto

1 adds 10 and the other adds 11 - i was under the understanding that the more queries it makes to the database the slower the board will be.So with these 2 hacks alone that is 21 queries and both are popular hacks.

Again, it really depends on the nature of them, if they are simple selects on an indexed column then they will run very quickly and not have too much impact, esp if they get cached by mysql. It also depends on how often they are run.

That said, 10+ is a lot, and it maybe that a change in the design of the mod could cut them down.

I'm curious to know which they are.

[King Kovifor]

Someone mentioned my Welcome Panel Template Rewrite in my thread. It adds 11.

[lasto]

was me King Kovifor.Your hack is good,so is loads of others on here but i think people should be told how many queries they add to the overall running of the board as some people who are new wont know and tbh proberly wont care if there queries run to about 50 or more.
Not calling your hack or anyone elses,but a simple box to input How many queries etc is not to much to ask for.
But upon reading the posts above it seems i am wrong and its not the actual querying thats a problem so long as the code is good.

[Dean C]

Think less about queries. There's a lot more too optimization than simply your interaction with the database server. Think about your memory usage, think about how you can avoid un-necessary loops etc.