Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^3: same query, different execution, different performance

by Marshall (Abbot)
on Feb 14, 2012 at 01:58 UTC ( #953585=note: print w/replies, xml ) Need Help??


in reply to Re^2: same query, different execution, different performance
in thread same query, different execution, different performance

Gee, at the moment I don't know how to explain it better - sorry if my English is confusing. Look again and see what is known when the prepare method is called. Read tye's post and look at the link which gives exactly the parameter needed to cause more to happen at execute() time rather than using the pre-prepared not so good default strategy - when preparing the statement, the DB just does a lot better if it knows "like something starting with abc" rather than "like something". The default is to use the info and strategy decided upon when the prepare statement was executed, but that behavior can be over-ridden.

  • Comment on Re^3: same query, different execution, different performance

Replies are listed 'Best First'.
Re^4: same query, different execution, different performance
by Anonymous Monk on Feb 14, 2012 at 10:20 UTC

    Gee, at the moment I don't know how to explain it better - sorry if my English is confusing. ...

    That is understandable. The sql is the query, sql, structured query language, its literally the same string :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://953585]
help
Chatterbox?
[shmem]: perldigious: as always - if it ain't broke, don't fix it. Ther must be a very compelling reason for changing column names in a database. Those are rare.
[Corion]: If you have whitespace in the column names in the database, whap the DBAs ;)
[shmem]: It's common for some vendors to have column names such as WRSTVG or some other such whizzbang, and another table where these names are mapped to something meaningful depending on how you look at the data
[shmem]: afair in SAP that occurs all the time

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (11)
As of 2017-05-25 13:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?