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
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
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
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
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
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
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
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
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
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
:)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
LEARN ABOUT DEBIAN
dbix::class::schema::loader::dbobject::informix
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)