Trending Database Solutions Discussions

What hints are considered useful for a system admin to speed up large database import ?‎

Database server running mysql5‎

Answers:

5

Followers:

1

Views:

274

Vote Count:

3

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

Database Engine: PostgreSQL‎

Answers:

3

Followers:

1

Views:

213

Vote Count:

1

What advice will you give to someone who (as an Electrical/ICT Engineer) is eager to work in the UAE, but has had no luck so far in finding a job.‎

Answers:

1

Followers:

1

Views:

98

Vote Count:

0

What is the difference between relational database and non-relational databases?‎

Answers:

0

Followers:

0

Views:

2

Vote Count:

0

 

Answer added by  Zaid Rabab'a, Software Development Team Leader, Al-Safa Co. Ltd.
10 years ago

compress it with Winrar or winzip and import them

 

Answer added by  Rami Zebian, CEO, LeLaboDigital
11 years ago

Save the files in .csv format and perform a Batch insert using a query ("bulk insert" for example) instead of the regular importing.

 

Answer added by  binu poovakunnil, SAFETY OFFICER, AL DARWISH ENGINEERING
8 years ago

KEEP PATIENCE SOON YOUR CHANCE WILL COME,BELIEVE IN GOD AND TRY HARDER.

 

Answer added by  Deleted user
9 years ago

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 ... See More

 

Answer added by  Ameer Pasha Md, Senior Software Analyst, intergraph
10 years ago

Explore clustering. Thats one option

 

Answer added by  Syed Waqas Ahmed Shah, Developer
10 years ago

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