vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin.org Site Feedback (https://vborg.vbsupport.ru/forumdisplay.php?f=7)
-   -   Runs/Adds Queries (https://vborg.vbsupport.ru/showthread.php?t=98766)

Xenon 10-19-2005 04:13 PM

Quote:

Originally Posted by peterska2
now I've gone off the idea!!!!

perfect, less work again :)

Andreas 10-19-2005 04:21 PM

DB Changes = The Hacks modifies the database schema (eg. adding new fields, tables, indexes, etc.)
It has nothing to do with queries it uses to do it's work (gather data to display or whatever).

Corriewf 10-19-2005 04:23 PM

Quote:

Originally Posted by Chris M
It even comes with a scrolling marquee saying [high]Chris M is the greatest[/high] :)

Chris


Lies it spreads...LIES!

Alan @ CIT 10-19-2005 04:32 PM

I've never understood this obsession with hacks and their SQL queries.

Merging 4 threads and moving the merged thread to a different forum using inline moderation, runs 102 queries - why would you care if a hack adds a query or 2 that take a fraction of a second to run?

But... that's just me :)

kall 10-19-2005 07:55 PM

Quote:

Originally Posted by peterska2
Cool. I'm looking forward to this hacks database, it's gonna be ace.

It's going to be ... me?

Oh... right. :)

Chris M 10-19-2005 08:00 PM

Quote:

Originally Posted by Alan @ CIT
I've never understood this obsession with hacks and their SQL queries.

Merging 4 threads and moving the merged thread to a different forum using inline moderation, runs 102 queries - why would you care if a hack adds a query or 2 that take a fraction of a second to run?

But... that's just me :)

The only time that could become a concern is with a badly scripted modification that runs excessive queries...

And since the days of 3.0 and especially 3.5 you don't need to execute as many queries thanks to improvements in functionality ;)

Chris

Snake 10-19-2005 09:56 PM

Oh I'm glad to hear this will be available while we're on 3.5. :)

Lea Verou 11-18-2005 07:10 PM

Ι remember asking about queries when I didn't even know what a query was! I don't think that everyone that seems so concerned about them really knows how much they add and what a query actually means.
I think some people are obsessed with the number of queries for no reason.
Anyway, DB changes is not complete cause there are hacks that don't affect the database but only run queries to read from it. So a query field is needed since we have those does-it-run-queries maniacs :p :p

noppid 11-18-2005 07:16 PM

It's not necessarilly the number of queries, but the quality of the queries. One badly written or implemented query can be worse then 100 properly implemented queries.

Lea Verou 11-18-2005 07:18 PM

Quote:

Originally Posted by noppid
It's not necessarilly the number of queries, but the quality of the queries. One badly written or implemented query can be worse then 100 properly implemented queries.

And how do you define a badly written query? :confused:


All times are GMT. The time now is 05:26 PM.

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.00990 seconds
  • Memory Usage 1,736KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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