| Re: str_replace does not like empty quotes [message #186309 is a reply to message #186299] |
Tue, 24 June 2014 02:34   |
Geoff Muldoon
Messages: 19
Registered: July 2011
Karma:
|
Junior Member |
|
|
jstucklex(at)attglobal(dot)net says...
> Have you ever worked on a high-active site? Say 1K hits/second or
more?
> And have you ever profiled bind values on such a site? I have.
Most high-activity sites I've worked on have used Oracle rather than
MySQL, and Oracle is much better at targetting and maintaining bind
variable execution plans in cache. You may be right that MySQL gains
less and could suffer more from using them.
Additionally, just because a site has high volumes that doesn't
necessarily mean lots of different SQL statements. I've worked on very
high volume sites where 80+% of the database calls are made using less
than 10 different queries - find a product, add product to order
(looping), show an order, write an invoice, etc. In these cases, with
correct cache size tweaking, performace was substantially improved by
using bind variables.
GM
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]