Sponsored Content
Top Forums Shell Programming and Scripting Doubt about multiple processes Post 302142593 by matrixmadhan on Sunday 28th of October 2007 05:08:55 AM
Old 10-28-2007
Can you provide some more information ?

Which database are you using ?
and what about the status of the columns being used for searching and updating.

Are the fields indexed, if so obviously search is going to be faster.

I have tried this in Informix and not in Oracle.
When you have to do an update on a table : column based on a value from table2 : column2, there is an option in Informix to do parallelized search where you have to specify only the number of threads in which the search has to run.

And the approach is much faster on the indexed columns.

for n number of rows from 1 .. n
Based on ' m ' threads number of records would be split as
1 .. k, k+1 .. k<n> , and k <m> .. n

and the results are internally manipulated.

Would this help you ?
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

processes statistics doubt

The following is the o/p I got when i run prstat -t command on SunOs5.8 NPROC USERNAME SIZE RSS MEMORY TIME CPU 2 shah 3152K 2384K 0.0% 0:00.00 0.0% 8 oracle 14G 13G 100% 5:09.04 0.0% 35 root 88M 54M 0.4% 0:54.27 0.0% 1 bb ... (3 Replies)
Discussion started by: shahnazurs
3 Replies

2. UNIX for Advanced & Expert Users

Crontab spawning multiple at processes

Hi - I need help. My user crontab is spawning multiple at processes (and multiple mencoder program starts, that exit, then restart, repeatedly), locking up my system. For example I have this entry in my crontab: $ sudo crontab -u victoria -e * * * * * ~/recordings/pvr1 * * * * *... (10 Replies)
Discussion started by: gstuart
10 Replies

3. Shell Programming and Scripting

multiple processes overlap

Hello I've got a script that creates multiple processes, in ksh, to bcp out 6 tables at a time. In the script, we write messages to the log to show our progress; most of the time, the log messages are nice and neat with one per line, like they should be. But every once in awhile, at random, the... (2 Replies)
Discussion started by: stonemonolith
2 Replies

4. UNIX for Dummies Questions & Answers

Running multiple processes in Linux

Hi guys, I want to run the multiple scripts at the same time using a ksh script. For example, I have three scripts to run: a.ksh, b.ksh and c.ksh How to start the above 3 scripts simultaneously and then on the completion of the above scripts I have other tasks to schedule. Thanks Gary (6 Replies)
Discussion started by: abcabc1103
6 Replies

5. Programming

Program to spawn multiple processes

I'm trying to make a program that will spawn multiple child processes then exit. I'm having trouble figuring out how to do this since after I fork, the child process begins running the program again (never ending). int main(void){ for(int i = 0; i < 3; i++){ fork(); }... (1 Reply)
Discussion started by: cagney58
1 Replies

6. Programming

Creating Multiple Processes

I am having problems creating multiple forks. I want create a certain number of forks, each call a program and each wait for a different value. How is this accomplished my loop is not doing the trick. for (i = 0; i < 5; i++) { if (fork() < 0) { //print error } ... (3 Replies)
Discussion started by: Vikings1201
3 Replies

7. Programming

Capture stdout from multiple processes

I have a number of binaries which I currenlty have no control over. They alright data to stdout. I would like to kick off any number of these binaries and capture and process their stdout. Doing this for one process is straight forward for example - comments and error checking removed for... (6 Replies)
Discussion started by: dvales
6 Replies

8. Shell Programming and Scripting

kill multiple processes by name

Want to kill multiple processes by name. for the example below, I want to kill all 'proxy-stagerd_copy' processes. I tried this but didn't work: >> ps -ef|grep proxy_copy root 991 986 0 14:45:34 ? 0:04 proxy-stagerd root 1003 991 0 14:45:49 ? 0:01... (2 Replies)
Discussion started by: catalinawinemxr
2 Replies

9. Solaris

Multiple hanged FTP processes

Hello people, I got one problem with a script. I have a script which runs every five mins and in the script an ftp process is invoked which sends files to a particular location. The problem is that the ftp process hangs every now and then which causes the whole script to hang. As the... (4 Replies)
Discussion started by: m_usmanayub
4 Replies

10. Shell Programming and Scripting

need help ps -e on multiple processes

:)Hi there, I am new to scripting and wanted to see if someone can show me how to grep on multiple processes and send the output to a file in /home/mydir/output. I am aware of ps -ef | grep on 1 process but need help looking up multiple processes, can you use this command ps -elf | grep |pid1... (4 Replies)
Discussion started by: abbya
4 Replies
DBIx::Class::Schema::Loader::DBObject::Informix(3pm)	User Contributed Perl Documentation   DBIx::Class::Schema::Loader::DBObject::Informix(3pm)

NAME
DBIx::Class::Schema::Loader::DBObject::Informix - Class for Database Objects for Informix Such as Tables and Views in DBIx::Class::Schema::Loader DESCRIPTION
This is a subclass of DBIx::Class::Schema::Loader::DBObject that adds support for fully qualified objects in Informix including both "database" and schema of the form: database:owner.object_name METHODS
database The database name this object belongs to. Returns undef if ignore_schema is set. sql_name Returns the properly quoted full identifier with "database", schema and name. SEE ALSO
DBIx::Class::Schema::Loader::Table::Informix, DBIx::Class::Schema::Loader::DBObject, DBIx::Class::Schema::Loader::Table, DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader. LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-05-05 DBIx::Class::Schema::Loader::DBObject::Informix(3pm)
All times are GMT -4. The time now is 10:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy