Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL ASP.NET4.0
I am using mysql database with .net
My problem is can I run mysql insert query after some delay of time.
I don't know how to handle multiple query from web page request. If two or more user hit web page at the same time then how to handle database.
How can I stop operation of mysql database when one operation/transaction is going from web page.please help I don't have any idea about it.
How to handle multiple insert, auto generate number,update,delete from web site.
Please help me.
 

[edit]SHOUTING removed, Spurious bold removed - OriginalGriff[/edit]
Posted 14-Feb-13 2:33am
Edited 14-Feb-13 2:52am
(no name)1.1M
v2
Comments
OriginalGriff at 14-Feb-13 7:52am
   
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.
Asim Mahmood at 14-Feb-13 8:32am
   
Please explain you question why you need to delay and how you are inserting data in DB.
Member 8825505 at 14-Feb-13 11:27am
   
if two user hit save button at the same time how it will managed.if i make mysql table lock for fraction of time when query 1st executes after that table is free for next query.but i don't how to implement this.
SRSHINDE at 9-Apr-13 23:54pm
   
This is called as concurrency control. Please read http://databasemanagement.wikia.com/wiki/Concurrency_Control to understand how you can handle this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 386
1 Marcin Kozub 225
2 Sergey Alexandrovich Kryukov 215
3 /\jmot 189
4 Praneet Nadkar 173
0 OriginalGriff 8,289
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,624
3 Maciej Los 4,989
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 14 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100