 |
|
|
Article Options |
|
[vB 4.1.3+] Get rid of one query per page with a simple configuration change
 Andreas
Join Date: Jan 2004
Posts: 6,856
I am still alive ... unfortunately. Germany
by
07 May 2011
Rating:
 (1 vote
- 5.00 average) If you are running vBulletin 4.1.3+ and you do not have set a Server SQL Mode you can get rid of one query on ervery page by adding
to your config.php To verify that no mode is set run
If both queries give empty results no mode is set and you can safely add the configuration setting. No members have liked this post.
|
||||||||
|
Views: 4528
|
||||||||
| Comments |
|
#2
07 May 2011, 14:49
|
||||
|
||||
|
great tip - thanks for sharing!
__________________
Latest Articles: Liquid Layout = Less Ad Revenue? How to Monetize Your Site Improve Web Page Performance How To Write For The Web If it needs instructions, there's room for improvement. Give users what they actually want, not what they say they want. And whatever you do, don't give them new features just because your competitors have them! No members have liked this post.
|
|
#3
11 May 2011, 20:15
|
||||
|
||||
|
Originally Posted by Princeton
Ditto 
 .
__________________
Search - Some often wonder why many do not reply to their posts... has the same question been answered before? *Use the search feature. Information - Posting for help or asking a question? *Include screenshots, copied/pasted code or errors, url. Fixed - Please return to your thread/post and disclose how you resolved the issue! *Helpful for those with a similar issue in the future i.e. possibly a solution! Thanks - Thanks for your participation on vbulletin.org! ♥ No members have liked this post.
|
|
#4
26 Jun 2011, 17:24
|
||||
|
||||
|
Where in AdminCP does it say set Server SQL Mode?
No members have liked this post.
|
|
#5
26 Jun 2011, 20:32
|
||||
|
||||
|
Nowhere. You can check by running the above query.
__________________
How to keep your board from getting blacklisted as a spammer The vBulletin Add-on Directory Block spam bots, content scrapers & malicious bots with vb Bad Behavior: save bandwidth costs and server resources. No members have liked this post.
|
|
#6
26 Jun 2011, 20:41
|
||||
|
||||
|
Awesome! Thanks!
--------------- Added 26 Jun 2011 at 21:18 --------------- Would it be possible to make this a plugin versus editing the config.php file?
__________________
 Posting for support? Read THIS first Do NOT PM me unless I asked you to. Your PM will be deleted and ignored! Do NOT IM me unless I asked you to. You will be added to my ignore list! Chuck Norris once shot an enemy plane down with his finger.... by yelling, “Bang!” No members have liked this post.
|
|
#7
30 Jun 2011, 20:44
|
||||
|
||||
|
Running the check above i get the return
@@GLOBAL.sql_mode; @@SESSION.sql_mode; So am i advised not to use this edit? Thanks just wanted to be double sure
__________________
http://www.ProFifaLeagues.com The community is our passion. Home of the best community for Xbox 360 gamer's. No members have liked this post.
|
|
«
Previous Article
|
Next Article
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
| Article Options | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 03:54.