| Re: str_replace does not like empty quotes [message #186315 is a reply to message #186313] |
Tue, 24 June 2014 12:01   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 6/24/2014 7:12 AM, Doug Miller wrote:
> Geoff Muldoon <geoff(dot)muldoon(at)trap(dot)gmail(dot)com> wrote in news:MPG.2e138ecff04eddb9d1
> @news.albasani.net:
>
> [...]
>> Additionally, just because a site has high volumes that doesn't
>> necessarily mean lots of different SQL statements.
>
> I would argue just the opposite, in fact -- the higher the volume, the more likely that a large
> number of SQL statements are substantially the same.
>
>> 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.
>
> Exactly so.
>
The number of SQL statements is not based on the volume; rather it is
based on what the site does. If all you have is a shopping cart, the
number of SQL statements is going to be low. Other sites have a much
larger number of SQL statements.
--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]