Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to optimize the loop to load parallelly
Top Forums Shell Programming and Scripting Need to optimize the loop to load parallelly Post 302997947 by jim mcnamara on Tuesday 23rd of May 2017 08:02:26 AM
Old 05-23-2017
I am going to guess: your code is an example but not what you are really loading.

If really it is what you are loading, then it appears to be a total waste of resources.
You could write a simple database procedure or trigger to take a number and multiply it by 10.

There are database optimizations you can easily do, example:
Does the table have index(es)? If yes, turn them off during the load. After, rebuild them.

You will have to check resources during a trail run - rbatte explained that really well.

Since you do not mention what UNIX and db you are using, we cannot help you on measuring resource usage.

If you want that help, tell us about your system: OS, shell, and database (like oracle, sybase, mysql, etc.).

It is up to you to help us to help you.
This User Gave Thanks to jim mcnamara For This Post:
rbatte1
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Running three scripts parallelly

Hi All, We have three shell script batch, which extract data from three different systems(oracle, db2, db2/400). By running each shell script batch, the data is extracted from respective systems. while the batch is running, job date, system_name, start_date and end_date will be inserted into... (1 Reply)
Discussion started by: anwarsait
1 Replies

2. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

3. Shell Programming and Scripting

pl help me to Optimize the given code

Pl help to me to write the below code in a simple way ... i suupose to use this code 3 to 4 places in my makefile(gnu) .. **************************************** @for i in $(LIST_A); do \ for j in $(LIST_B); do\ if ;then\ echo "Need to sign"\ echo "List A = $$i , List B =$$j"\ ... (2 Replies)
Discussion started by: pk_arun
2 Replies

4. UNIX for Dummies Questions & Answers

VPS has load 200, httpd load no activity, netstat nothing

Hello, on my hostserver i see one VPS of mine got load of 200.00 and netstat nothing (not a single blank line on netstat command) after some time, netstat started showing connections, but i see no excessive IP connections. tail -f /var/log/httpd/access_log shows no activity /var/log/messages ;... (1 Reply)
Discussion started by: postcd
1 Replies

5. Shell Programming and Scripting

Search patterns in multiple logs parallelly.

Hi All, I am starting a service which will redirect its out put into 2 logs say A and B. Now for succesful startup of the service i need to search pattern1 in log A and pattern2 in log B which are writen continuosly. Now my requirement is to find the patterns in the increasing logs A and B... (19 Replies)
Discussion started by: Girish19
19 Replies

6. Shell Programming and Scripting

Executes scripts parallelly based on their success

Hi Team , I have one Master.sh file which call X,Y,Z scripts , but here X may call again some sub scripts X_sub1.sh , X_sub2.sh Y calls Y_sub1.sh,Y_sub2.sh and similarly Z script also . Now requirement is Both X and Y should execute parallel bcz X and Y are independent... (9 Replies)
Discussion started by: chandini
9 Replies

7. Shell Programming and Scripting

To execute scripts parallelly

Hi I have set two set of scripts sets in a file which perform similar operations but with different script names for e.g.: 1st set of script1.txt: 1.sh 2.sh 3.sh 4.sh 2nd set of script2.txt: 1_1.sh 2_1.sh 3_3.sh 4_4.sh I want to execute these set of scripts parallelly in such... (16 Replies)
Discussion started by: rohit_shinez
16 Replies

8. Shell Programming and Scripting

Optimize my mv script

Hello, I'm wondering if there is a quicker way of doing this. Here is my mv script. d=/conversion/program/out cd $d ls $d > /home/tempuser/$$tmp while read line ; do a=`echo $line|cut -c1-5|sed "s/_//g"` b=`echo $line|cut -c16-21` if ;then mkdir... (13 Replies)
Discussion started by: whegra
13 Replies

9. Shell Programming and Scripting

Looking to optimize code

Hi guys, I feel a bit comfortable now doing bash scripting but I am worried that the way I do it is not optimized and I can do much better as to how I code. e.g. I have a whole line in a file from which I want to extract some values. Right now what I am doing is : STATE=`cat... (5 Replies)
Discussion started by: Junaid Subhani
5 Replies

LEARN ABOUT MOJAVE

pkg::create

pkg::create(n)						       Tcl Built-In Commands						    pkg::create(n)

__________________________________________________________________________________________________________________________________________________

NAME

       pkg::create - Construct an appropriate 'package ifneeded' command for a given package specification

SYNOPSIS

       ::pkg::create -name packageName -version packageVersion ?-load filespec? ... ?-source filespec? ...
_________________________________________________________________

DESCRIPTION

       ::pkg::create  is  a utility procedure that is part of the standard Tcl library.  It is used to create an appropriate package ifneeded com-
       mand for a given package specification.	It can be used to construct a pkgIndex.tcl file for use with the package mechanism.

OPTIONS

       The parameters supported are:

       -name packageName
	      This parameter specifies the name of the package.  It is required.

       -version packageVersion
	      This parameter specifies the version of the package.  It is required.

       -load filespec
	      This parameter specifies a binary library that must be loaded with the load command.  filespec is a list	with  two  elements.   The
	      first  element  is  the name of the file to load.  The second, optional element is a list of commands supplied by loading that file.
	      If the list of procedures is empty or omitted, ::pkg::create will set up the library for direct loading (see pkg_mkIndex).  Any num-
	      ber of -load parameters may be specified.

       -source filespec
	      This  parameter  is  similar to the -load parameter, except that it specifies a Tcl library that must be loaded with the source com-
	      mand.  Any number of -source parameters may be specified.

       At least one -load or -source parameter must be given.

SEE ALSO

       package(n)

KEYWORDS

       auto-load, index, package, version

Tcl									8.3							    pkg::create(n)
All times are GMT -4. The time now is 12:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy