_
_ Handy PHP
_
_
Tutorials, Scripts, Information And Other Resources arrow Forum
Sunday, 07 September 2008
_

Refer A Friend using Revolution Money Exchange
Resource Menu
Handy PHP Store
Free Domain Name
PHP Functions
PHP Downloads
PHP Newsfeeds
PHP Tutorials
Webmaster Tools
User Login
TalkPHP
Get friendly help with your PHP problems for free.
www.talkphp.com
The PHP Resource Index
Handy PHP
Free PHP Help!

FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Joomla Extensions Joomla Mambots
Perfomance loss adding LOWER statement? (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Perfomance loss adding LOWER statement?
#334
revertm (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Perfomance loss adding LOWER statement? 2 Months ago Karma: 0  
Hi Vujsa and people of the forum!

I was reading about performance increases eliminating all LOWER statememts before any field in Joomla searchbots (1.0.x version at least).
Explanations of this are based in the argument that, by default, MySQL searches are not case sensitive. So, adding LOWER statements in WHERE clauses may increase the stress in database.

What do you think about this?
I didnt't tried anything yet, but I need your opinion like my favorite expert in Joomla searchbots

I'm running an Intranet site whit a constant and very stressfull use of searchbots: Any gain of performance wil be gold for me.
Some searchbots I've developed are plenty of LOWER, only to mimic the bots made by original developers of Joomla.

So...What do you think about this?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
_
 
_
_
© 2008 Handy PHP