Doubt about multiple processes

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Doubt about multiple processes
# 8  
Old 10-29-2007
What you had displayed is the datatype of the columns in the table and seems that the columns that you are interested are not indexed.

So internally query process would not be much faster when compared to the query that are run over indexed columns.

One more suggestion would be to,
construct generic search query with varying variable values,
something like
update table set col1 = <value1> where col2 = <value2>;

Here only the value1 and value2 would be modified and effectively there is no need to construct the query, do parsing, do semantic and syntactic checking, construct query tree, so only variables would be added as and when new values are encountered.

You could have internal logic to split the chunk of data and pass the same query to different chunks at the same time and reconcile the output.

Hope am making some sense here, if not shout at me Smilie
# 9  
Old 10-29-2007
Well... I'm not sure if I completely understood that but looks interesting for sure... Do you mean that I should be creating a new table instead of updating the column in the existing table? (Don't hate me for this... the terminologies are quite new so I might have written something that doesn't make sense)

PS: I've actually started that query that I was talking about in my Unix Server (Yeah, I really mean it - its a full fledged server)... Will just see if it completes by morning... But I think with your advices, I might be able to construct some efficient way of doing things... Smilie
# 10  
Old 10-29-2007
One weird problem though... When I'm trying to either count or display the rows in a table (Limiting to 15) or even sometimes trying to access the databases, its just hanging up and not letting me to do anything... Why is this happening?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

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

8. 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

9. 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

10. 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
Login or Register to Ask a Question