11-30-2011
Thank you again for your contribution on this. Just ran the statement again on a slightly faster machine and achieved 0.41 seconds without indexes and 0.98 seconds with indexes. So the indexing strategy clearly needs some tweaking, but the overall approach is very promising.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello all,
I'm new here, so this information may exist elsewhere on this forum. If so, please point me in the right direction.
Here's the problem.
I'm trying to migrate Oracle data from an HP system to a Sun system using a raw device as a 'bridge' between the two systems. Both machines... (4 Replies)
Discussion started by: Neville
4 Replies
2. Shell Programming and Scripting
Hi guys
I have a need to compress the contents of a directory while I am copying data into it. I was able to do this when it was only one file by doing as below:
STEP1: mknod myfile p
STEP2: chmod 777 myfile
STEP3: compress -v < myfile > myfile.Z &
STEP4: cp -p xyz_file myfile... (2 Replies)
Discussion started by: user1602
2 Replies
3. Shell Programming and Scripting
Hii friends,
I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit :confused:..
My requirement is somewhat wierd,let me explain what i have and what i need to do...
1) there are several excel... (1 Reply)
Discussion started by: 5ahen
1 Replies
4. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
5. Programming
Hello, i'm new to the forum and so am i to C programming.
Recently i've gotten a task to create a program that will read an existing .bin file and copy the data to a non existing (so i have to create it) .txt file (some type of conversion)
Now, i now how to put the arguments, opening and... (5 Replies)
Discussion started by: Lyric
5 Replies
6. Shell Programming and Scripting
I have the following that I'd like to do:
1. I have split a file into separate files that I placed into the /tmp directory. These files are named F1 F2 F3 F4.
2. In addition, I have several directories which are alphabetized as dira dirb dirc dird.
3. I'd like to be able to copy F1 F2 F3 F4... (2 Replies)
Discussion started by: newbie2010
2 Replies
7. Solaris
Hello people,
I have a question regarding transferring data from one file server to another.
The server is a Solaris 9 box
The old file server is connected via Ethernet cable, and the new file server we are switching is a Fiber channel.
can I use the
dd if=server:/app1 of=server2:/app1
... (2 Replies)
Discussion started by: br1an
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a large number of data files each containing simple integers from 1 to around 25000 in ascending order. However, they are not in a specific progression; some numbers are missing in each file.
For ex. datfile1 may have the numbers in order 1 2 4 6 7 8 12 ... 24996 24999
while datfile2... (8 Replies)
Discussion started by: latsyrc
8 Replies
9. Red Hat
I need to perform operation as captioned.
I found out USB CD Drive is attached, by running 'lsusb' command.
I am trying to identify mechanism by which I could mount this USB CD drive to disk. After which I expect to copy the contents.
Could anyone indicate how this could be performed ? (3 Replies)
Discussion started by: videsh77
3 Replies
10. Programming
I need to fix an SQL statement in MySQL that should calculate a field using values from two of the columns and I prefer to do this using set-based programming, ie not procedural. What needs to happen is that in a separate column called "delta" the value of "level" is copied depending on whether... (3 Replies)
Discussion started by: figaro
3 Replies
LEARN ABOUT DEBIAN
doveadm-index
DOVEADM-INDEX(1) Dovecot DOVEADM-INDEX(1)
NAME
doveadm-index - Index mailboxes
SYNOPSIS
doveadm [-Dv] index [-S socket_path] mailbox
doveadm [-Dv] index [-S socket_path] -A mailbox
doveadm [-Dv] index [-S socket_path] -u user mailbox
DESCRIPTION
Add unindexed messages in a mailbox into index/cache file. If full text search is enabled, also add unindexed messages to the fts database.
The caching adds only the fields that were previously added to the mailbox's caching decisions, so it won't do anything useful for mail-
boxes that user's client hasn't accessed yet. You can use doveadm dump command to show a specific mailbox's current caching decisions.
OPTIONS
Global doveadm(1) options:
-D Enables verbosity and debug messages.
-v Enables verbosity, including progress counter.
Command specific options:
-A If the -A option is present, the command will be performed for all users. Using this option in combination with system users from
userdb { driver = passwd } is not recommended, because it contains also users with a lower UID than the one configured with the
first_valid_uid setting.
When the SQL userdb module is used make sure that the iterate_query setting in /etc/dovecot/dovecot-sql.conf.ext matches your data-
base layout. When using the LDAP userdb module, make sure that the iterate_attrs and iterate_filter settings in /etc/dovecot/dove-
cot-ldap.conf.ext match your LDAP schema. Otherwise doveadm(1) will be unable to iterate over all users.
-S socket_path
The option's argument is either an absolute path to a local UNIX domain socket, or a hostname and port (hostname:port), in order to
connect a remote host via a TCP socket.
This allows an administrator to execute doveadm(1) mail commands through the given socket.
-u user/mask
Run the command only for the given user. It's also possible to use '*' and '?' wildcards (e.g. -u *@example.org).
When neither the -A option nor -u user was specified, the command will be executed with the environment of the currently logged in
user.
ARGUMENTS
mailbox
The name of the mailbox to index.
EXAMPLE
Index bob's INBOX:
doveadm index -u bob INBOX
REPORTING BUGS
Report bugs, including doveconf -n output, to the Dovecot Mailing List <dovecot@dovecot.org>. Information about reporting bugs is avail-
able at: http://dovecot.org/bugreport.html
SEE ALSO
doveadm(1)
Dovecot v2.1 2011-05-11 DOVEADM-INDEX(1)