Interested to Buy Any Domain ? << Click Here >> for more details...
can anyone explain about stored procedure,Triggers and
transaction in php?
- 2 Answers
- 6179 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jit
A stored procedure is simply a procedure that is stored on
the database server. MySQL developers have to date
unthinkingly written and stored their procedures on the
application (or web) server, mainly because there hasn't
been an option. That has been limiting. Some have claimed
that there are two schools of thought - one claiming that
logic should be in the application, the other saying it
should reside in the database. However, most professionals
would not bind themselves to one or other viewpoint at all
times. As always, there are times when doing either makes
sense. Unfortunately, some of the staunchest adherents of
the in the application school are only there because until
now they have had no choice, and it is what they are used to
doing.
Triggers are programmable events that react to queries and
reside directly on the database server. Triggers can be
executed before or after INSERT, UPDATE or DELETE
statements.There are several reasons to use triggers.
Triggers can automate a lot of stuff that you may have been
doing by hand before. The main reason I use triggers is to
maintain the integrity of one table that might rely on
another table. For example, if TableA references TableB and
a value from TableB gets deleted, you could have a trigger
setup to handle the data in TableA. Perhaps the data in
TableA should be reset to a generic value or maybe the data
should just be deleted completely.
| Is This Answer Correct ? | 5 Yes | 0 No |
How to display your correct URL of the current web page?
What are the Advantages and Application Areas of PHP?
How many php based companies in bangalore and chennai and over all india ? most of the persons saying for 2 years and 3 years they will be getting less than 15k per month how far is it true ? is it good scope for experience people can any one tell the exact experience pay for php developers one yr experience how much sal we expect ? two yr experience how much sal we expect ? three yr expereince how much sal we expect ? please kindly reply to the above questions as an experts you only please kindly judge and tell your practical experience in PHP ?
please can any one tell is there any openings for freshers in PHP ...please tell the company name and address sir where can i find ..php related companies and how much i expect salary as a fresher in php ..i finished my LAMP course i done my mca ..i seen in many job portals there is no job for freshers in php can any one tel me please in chennai i need php jobs ..? thank u friends
What is exception in php?
What is the use of count() function in php?
How long is session timeout?
What is $row in php?
hi, i am new for php I want to know where to create & how to run phpscript programme in LAMP?
What does the expression exception::__tostring means?
discuss the issue of software theft in ghana and how it has affected the economy
How do you create an array in php?
PHP 
