Interested to Buy Any Domain ? << Click Here >> for more details...
can anyone explain about stored procedure,Triggers and
transaction in php?
- 2 Answers
- 6301 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasadkonnur
A stored procedure is a set of SQL commands that can be
compiled and stored in the server. Once this has been done,
clients don’t need to keep re-issuing the entire query but
can refer to the stored procedure.This provides better
overall performance because the query has to be parsed only
once, and less information needs to be sent between the
server and the client. However, stored procedures of
course do increase the load on the database server system,
as more of the work is done on the server side and less on
the client (application) side.
A trigger is effectively a type of stored procedure, one
that is invoked when a particular event occurs.For example,
you can install a stored procedure that is triggered each
time a record is deleted from a transaction table and that
stored procedure automatically deletes the corresponding
customer from a customer table when all his transactions are
eleted.
Indexes are used to find rows with specific column values
quickly.Without an index, MySQL must begin with the first
row and then read through the entire table to find the
relevant rows. The larger the table, the more this costs. If
the table has an index for the columns in question, MySQL
can quickly determine the position to seek to in the
middle of the data file without having to look at all the
data. If a table has 1,000 rows, this is at least 100 times
faster than reading sequentially. If you need to access most
of the rows, it is faster to read sequentially, because this
minimizes disk seeks.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to get the total number of values in an array?
What is the difference between Session and Cookie?
How variables are passed through arguments?
Why did you choose this particular career path?
Explain the changes in php versions?
How are variables declared in php?
What are string functions?
What are the 5 types of data?
Tell me how do I escape data before storing it into the database?
How to initiate a session in php?
Which cryptographic extension provide generation and verification of digital signatures?
Name some of the functions in php.
How do you remove whitespace from the beginning and end of a $string variable?
What is the difference between php 5 and php 7?
List some string function name in php?
