Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to handle a huge concurrent inserts on a database table?

user-image
Question ajoutée par Badr Ghatasheh , Software Engineer , bayt.com
Date de publication: 2013/06/11
Utilisateur supprimé
par Utilisateur supprimé

you can Use SQL SCRIPT wich is a set of SQL commands saved as a file in SQL Scripts. A SQL script can contain one or more SQL statements or PL/SQL blocks. You can use SQL Scripts to create, edit, view, run, and delete script files.

at last in script file use commit or commitretaining for validation of all operation

 

Ameer Pasha Md
par Ameer Pasha Md , Senior Software Analyst , intergraph

Explore clustering. Thats one option

Syed Waqas Ahmed Shah
par Syed Waqas Ahmed Shah , Developer

that depends on your requirement. Normally Database row locking along with transactions are used for concurrent inserts.

More Questions Like This