concurrent access of a stored procedure 
Author Message
 concurrent access of a stored procedure

Hi There,
What happens when 2 or more clients execute a stored procedure at the same
time.
Will every One get the same results, (can they actually execute).
How about the extended stored procedures(of Sql server)
Thanx for any info.
-- Praasd

--
######################################################################
#       Help ALL and Hurt None                                       #
#       http://www.***.com/ ;                        #
######################################################################



Sun, 10 Jan 1999 03:00:00 GMT
 concurrent access of a stored procedure

I have put a questionaire about commercial sybase tools/utilites on my
web site:

http://www.tiac.net/users/sqltech

This is a completly non-commercial activity.  The results will be
submitted to comp.databases.sybase provided there are adequate hits.
I'm doing this out of
curiosity - i've been wondering what tools people love and hate.

If you have 5 minutes, i would appreciate your checking it out and
filling it in.

Ed



Mon, 11 Jan 1999 03:00:00 GMT
 concurrent access of a stored procedure

: Hi There,
: What happens when 2 or more clients execute a stored procedure at the same
: time.
: Will every One get the same results, (can they actually execute).
: How about the extended stored procedures(of Sql server)
: Thanx for any info.
: -- Praasd

Stored procedures are not re-entrant.  When 2 clients try to execute the
same procedure, another copy of the procedure is created in cache and each
client executes its own copy of the procedure.  Underlying tables are
protected by locks so that the procedures do not step on one another.

--
+==============================+=============================================+
| David W. Pledger             | S T R A T E G I C   D A T A   S Y S T E M S |

| Custom Database Applications |        Phone: (800)253-5624 ext 2940        |
+==============================+=============================================+



Mon, 11 Jan 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. concurrent access of a stored procedure

2. Concurrent access to Oracle8.1.5 and Microsoft-access via ODBC within a PL/SQL-procedure

3. concurrent worksc in stored procedure

4. Concurrent Stored Procedure Execution

5. WLM and concurrent Stored Procedure load

6. stored proc. concurrent access

7. Calling a Java Stored Procedure from another Java Stored Stored Procedure

8. lock table for concurrent user-access with RDO and Access-Database

9. concurrent user-access with RDO and Access-Database

10. Accessing a Stored Procedure from an Access Module

11. Calling Oracle stored procedures from Access'97 and Access'2000

12. Concurrent Batches = Concurrent Connections?


 
Powered by phpBB® Forum Software