06-30-2010
I understand,
why don't you just update the files table at the end of each file processing? A single record update vs scheduled mass update.
P.S. If I understand correctly the last time update in the files table is the slowest part, right?
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file with multiple records...and I have to select records based on first column....here is the sample file...
I01,abc,125,1a2,LBVI02
I01,abc,126,2b5,LBVI02
I02,20070530,254,abc,LLBI01
I02,20070820,111,bvd,NGBI01
I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies
2. Shell Programming and Scripting
hi..
i need to optimize my select query ..
my situation is like this ..
i have 15 lac recors in my table..
the following query takes nine seconds to give the required output..
SELECT max(ah.AUC_AMT),
SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (0 Replies)
Discussion started by: senkerth
0 Replies
3. UNIX for Advanced & Expert Users
hi..
i need to optimize my select query ..
my situation is like this ..
i have 15 lac recors in my table..
the following query takes nine seconds to give the required output..
SELECT max(ah.AUC_AMT),
SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (1 Reply)
Discussion started by: senkerth
1 Replies
4. UNIX for Dummies Questions & Answers
Hi, I would just like to know how to get the file with the max filename on a directory and get rid of all the others. For example, in directory A:/ i have the ff files:
APPLE2001
APPLE2002
APPLE2003
GRAPE2004
what I want to get is the max in files whose filenames start with APPLE*,... (4 Replies)
Discussion started by: madden
4 Replies
5. Shell Programming and Scripting
I have a file with 3 columns
I want to get the record with the max salary. If there are more than 1 record having the highest salary, i want any one of them.
empid,ename,Sal
1,abc,100
2,def,200
3,xyz,300
4,pqr,100
5,mnq,300
Output
Any record with 300 as salary
Please use next... (1 Reply)
Discussion started by: traininfa
1 Replies
6. Programming
I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work.
Basically I wrote code like this:
select * from `Test_DC_Trailer` HAVING max(DR_RefKey);
Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)... (7 Replies)
Discussion started by: Astrocloud
7 Replies
7. Shell Programming and Scripting
I want records which have more than one and different value in the second column on the below sample file.
Ex, I have the samle file below :-
XYZ 1
XYZ 3
abc 1
abc 1
qwe 2
qwe 1
qwe 3
I want to select XYZ and QWE line only. (6 Replies)
Discussion started by: Sanjeev Yadav
6 Replies
8. Programming
Dear community,
I woul like to make a query to output all the users having the same IP address.
The table is somethig like:
name logged_ip
==== =========
user1 127.0.0.1
user2 127.0.0.2
user3 127.0.0.3
user4 127.0.0.1
user5 127.0.0.2
user6 127.0.0.5I used this query... (4 Replies)
Discussion started by: Lord Spectre
4 Replies
9. Shell Programming and Scripting
Hello,
I am working on an application that uses allot of memory depending on the input. I am also working on more than one processing algorithm.
The program has a long processing time (hours) so it would be nice to be able to monitor the maximum memory footprint of the application during runs... (1 Reply)
Discussion started by: LMHmedchem
1 Replies
LEARN ABOUT DEBIAN
bcron-update
bcron-update(8) System Manager's Manual bcron-update(8)
NAME
bcron-update - Update system crontabs.
SYNOPSIS
bcron-update path [ path ... ]
DESCRIPTION
bcron-update polls the named files or directories periodically to see if there are any new, changed, or removed files. When it detects
changes, it mirrors those changes into the crontab spool directory. bcron-update runs as root in order to be able to read system files
that would potentially be unreadable otherwise.
On Debian, if path is a directory, bcron-update skips files in this directory with names that do not solely consist of lower- and uppercase
letters ('a'-'z', 'A'-'Z'), digits ('0'-'9'), underscores ('_'), and hyphens ('-').
EXAMPLES
To mirror modern vixie-cron's behavior, use:
bcron-update /etc/crontab /etc/cron.d
ENVIRONMENT
BCRON_SPOOL
The spool directory for bcron. Defaults to /var/spool/cron.
BCRON_USER
After writing files and before moving them into their final location, bcron-update changes the ownership of the file to this user so
that bcron-sched can read them.
SEE ALSO
bcron-sched(8)
DIAGNOSTICS
bcron-update outputs three different kinds of messages about actions it is taking.
Rescanning /etc/cron.d
The named directory has been modified, and will be scanned to determine what files have been added or deleted.
-/etc/cron.d/oldfile
The named file no longer exists and will be removed from the spool.
+/etc/cron.d/newfile
The named file was either created or modified since the last scan, and will be copied into the spool.
AUTHOR
Bruce Guenter <bruceg@em.ca>
bcron-update(8)