vb.org Archive - Remove 1 Query Per Page

Page 2 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Remove 1 Query Per Page (https://vborg.vbsupport.ru/showthread.php?t=107701)

Kihon Kata

02-11-2006 10:32 PM

Quote:

Originally Posted by Trigunflame

Because if you would look at the query:

$this->registry->db->shutdown_query()

It is a shutdown query that is run as the script is ending, and is not shown in any query counters. Nevertheless it is still sending that query to your forums mysql database which affects the system.

I didnt say this would necessarily make your forum "Faster", I just said it would reduce a query, lol.

Go read my thread in vb3 if you dont believe me...

Oh, all I said is that when the stats lists, it's the same number of queries listed, that's all. Nothing about speed or "Faster".

Anyhow, thanks for this

Snake

02-12-2006 09:19 AM

Thank you very much. I always wanted to reduce the query usage on my forums but guess what, this helps a lot! :)

NuclioN

02-12-2006 09:48 AM

Trigunflame the code to replace at the very bottom of the last replacement says you have to overwrite. That section in the original has this:

Code:

$this->registry->db->shutdown_query("

                                                UPDATE " . TABLE_PREFIX . "user

                                                SET lastactivity = " . TIMENOW . "

                                                WHERE userid = " . $this->userinfo['userid'] . "

                                        ", 'lastvisit');

                                }

                        }

                }

        }

}

-----------------------

According to the manual i have to overwrite the first two } is that correct?

Trigunflame

02-12-2006 09:59 AM

Quote:

Originally Posted by NuclioN

Trigunflame the code to replace at the very bottom of the last replacement says you have to overwrite. That section in the original has this:

Code:

$this->registry->db->shutdown_query("

                                                UPDATE " . TABLE_PREFIX . "user

                                                SET lastactivity = " . TIMENOW . "

                                                WHERE userid = " . $this->userinfo['userid'] . "

                                        ", 'lastvisit');

                                }

                        }

                }

        }

}

-----------------------

According to the manual i have to overwrite the first two } is that correct?

Just replace the php code in the first php example, with the php code in the 2nd example.

NuclioN

02-12-2006 10:14 AM

Tnx :) Every reduce of query is usefull

o0Hubba0o

02-12-2006 03:22 PM

Quote:

3. Above that, paste the below

So does it go above? Or does it go below?

Wait, I think I understand now that I look at what I typed, your saying to paste what's below above this "$this->set('location', WOLPATH); " right? Maybe change it to say: "3. Above that, paste the following:". ;) Otherwise more people might get confused if they're looking at this right after getting up in the morning like me hehe.

Trigunflame

02-12-2006 08:37 PM

Quote:

Originally Posted by o0Hubba0o

It doesnt matter if you paste it below it or above it, just a 1 liner.

Trigunflame

02-18-2006 01:53 PM

*bump*

dutchbb

02-18-2006 03:24 PM

I'm still not sure what changes when I remove the query. And if it doesn't change speed I rather keep the extra query

Trigunflame

02-20-2006 07:12 PM

Quote:

Originally Posted by Triple_T

I'm still not sure what changes when I remove the query. And if it doesn't change speed I rather keep the extra query

If you dont care, dont worry about it :tired:

All times are GMT. The time now is 03:02 PM.

Page 2 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01408 seconds Memory Usage 1,739KB 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 (2)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: