| Re: str_replace does not like empty quotes [message #186310 is a reply to message #186309] |
Tue, 24 June 2014 03:07   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 6/23/2014 10:34 PM, Geoff Muldoon wrote:
> 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
>
It depends on the site. I've also used Oracle on websites (as well as
DB2 and SQL Server). Results vary quite a bit.
I've never seen a site where 80+% of the database calls are made with
less than 10 different queries. But then the sites I've worked on are
typically pretty complicated sites - not simple shopping carts. If all
you're doing is a shopping cart, then I can see where bind variables
might help.
But just because you find something works better in Oracle doesn't mean
it works better in MySQL. I find a lot of things work better in DB2,
for instance, than either Oracle or MySQL (try doing recursive SQL in
MySQL, for instance).
--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]