Click here to Skip to main content
15,879,535 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I AM DEVELOPING ASP.NET WEB SITE WITH MYSQL DATABASE.
MY PROBLEM IS HOW TO HANDLE DATABASE WHEN MANY SAVING REQUEST FROM DIFFERENT WEB PAGE.
I AM USING AUTO GENERATE ID IN REGISTRATION FORM BUT HOW MANY TIMES THE WEB PAGE RUN IT SHOULD BE DIFFERENT FOR ALL.HOW CAN I MAKE DUPLICITY CHECK AND HOW CAN I LOCK MYSQL TABLE WHEN ONE QUERY IS RUNNING FROM WEB PAGE FOR VERY SMALL AMOUNT OF TIME.
PLEASE HELP ME.
Posted
Updated 14-Feb-13 2:45am
v4
Comments
Nandakishore G N 14-Feb-13 7:47am    
no problem..the autogenerated ids wont get conflict
Member 8825505 14-Feb-13 11:21am    
auto generate no is unique but the problem is how to manage auto generate at each web page hit.like at same time two person visited the page at that time how i will manage.
Nandakishore G N 14-Feb-13 23:11pm    
the sql executes sequentially.no need to get worry it wont cause conflicts.
Member 8825505 14-Feb-13 23:32pm    
ok then we have to write simple code no need to handle it
Member 8825505 14-Feb-13 23:35pm    
can you give example like we have one page say registration when it is published let say two user visit page and save reg information at the same time then how mysql manage that.

1 solution

 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900