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
Code:
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
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...
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?
:)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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
10-29-2007
