Click here to Skip to main content
11,795,848 members (78,964 online)
Rate this: bad
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 1:33am
Edited 14-Feb-13 1:52am
(no name)1.4M
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 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 Maciej Los 410
1 Abhinav S 368
2 OriginalGriff 300
3 Sergey Alexandrovich Kryukov 266
4 KrunalRohit 249
0 OriginalGriff 1,852
1 Maciej Los 1,465
2 KrunalRohit 1,300
3 CPallini 840
4 Richard MacCutchan 828

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 14 Feb 2013
Copyright © CodeProject, 1999-2015
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