?
Solved

bind variables in php/mysql

Posted on 2004-03-22
4
Medium Priority
?
772 Views
Last Modified: 2008-02-01
Oracle has bind variables. Bind variables are used to avoid re-parsing requests. For example, if I say

"select * from someTable where number < 100"
and then
"select * from someTable where number < 5000"

the second query requires a complete reparse even though it is very nearly parsed 1 second ago. if 100 and 5000 could be handled by a variable of some type, the parsing could be skipped.

So does mysql have bind variables and can you use them with mysql.
0
Comment
Question by:rfr1tz
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:waygood
ID: 10652872
I havent come across that one yet I cant really see the need. If your going to process a query and then extend the query. Then theres going to be some overhead in doing this as you need to keep the previous query results.

Just a simple "WHERE number BETWEEN 100 AND 5000" would extend the query.
Or just "WHERE number < 5000 ORDER BY number" and process up to the point where number exceeds 100, and if necessary continue later.

I cant see any practical application of this, can you suggest one?

0
 
LVL 3

Author Comment

by:rfr1tz
ID: 10653304
We had an Oracle consutant in here and he said we should use bind variables to increase performance by avoiding re-parsing. That's pretty much all I know about it.

The consultant was very smart though. I think he was probably correct.
0
 
LVL 9

Accepted Solution

by:
waygood earned 1000 total points
ID: 10653355
How big is your database then?

Did you know that Oracle is the most expensive piece of software in the world (as of about a year ago)
How much is Mysql? FREEEEEE!!! for non-commecial use

and for what, shaving a few milliseconds off your queries?
0
 
LVL 3

Author Comment

by:rfr1tz
ID: 10668236
Obviously, cost is why I want to use mySql whenever I can. mySql is constantly improving and hopefully it will soon be as good as Oracle.

Like many other software tools, Oracle has become so complex that you need consultants to come in and audit your installation. I doubt that many people have even heard of "bind" variables much less use them.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses
Course of the Month14 days, 20 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question