BUTIL -INDEX 
Author Message
 BUTIL -INDEX

Is it possible to load data into an unindexed btrieve file, and then
create the indexes?  We need to dump out a lot of data, manipulate it,
and then load it back into a file.  I've read that it's faster to load
data with out the indexes, and then create them after the data is
there.  Does anyone have any experience with this?

We have to do this at the btrieve level, so I can't use any of the SQL
commands.  I know the command for this is:

BUTIL -INDEX <sourceFile> <indexFile> <descriptionFile> [/O<owner |
*>]

but am unsure of the usage - what is the indexFile?  what is the
descriptionFile?

Any help greatly appreciated.

Cynthia Merritt
National Travelers Life Co.



Wed, 19 Oct 2005 00:59:27 GMT
 BUTIL -INDEX

Yes, you can.  In fact, this is how the "Rebuild Utility" offers better
rebuild speeds than BUTIL.  The description file is defined in the
Pervasive manuals, so this is the best place to go.  You can either write
a program to use the Btrieve "Create Index" function, which requires a
specific data buffer, or you can use the BUTIL utility and provide a
description file.

One shortcut:  Use the GUI-based Maintenance Utility to create the index
definition!  In the "Information Editor", first define your index, then
click "Create File", and be sure to select "Description" and "Index
Only".  The resulting DES file can be passed to BUTIL!
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach (From Washington, DC)

 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago, Washington DC - See our web site for details!

Quote:

> Is it possible to load data into an unindexed btrieve file, and then
> create the indexes?  We need to dump out a lot of data, manipulate it,
> and then load it back into a file.  I've read that it's faster to load
> data with out the indexes, and then create them after the data is
> there.  Does anyone have any experience with this?

> We have to do this at the btrieve level, so I can't use any of the SQL
> commands.  I know the command for this is:

> BUTIL -INDEX <sourceFile> <indexFile> <descriptionFile> [/O<owner |
> *>]

> but am unsure of the usage - what is the indexFile?  what is the
> descriptionFile?

> Any help greatly appreciated.

> Cynthia Merritt
> National Travelers Life Co.



Wed, 19 Oct 2005 06:06:01 GMT
 BUTIL -INDEX
So the usage would be:

BUTIL -INDEX <databasefile.DAT> <INDEX FILE???> <descriptionfile.DES>

What exactly goes in the <INDEX FILE> spot?

Thank you so much for your help, Bill!

Quote:

> Yes, you can.  In fact, this is how the "Rebuild Utility" offers better
> rebuild speeds than BUTIL.  The description file is defined in the
> Pervasive manuals, so this is the best place to go.  You can either write
> a program to use the Btrieve "Create Index" function, which requires a
> specific data buffer, or you can use the BUTIL utility and provide a
> description file.

> One shortcut:  Use the GUI-based Maintenance Utility to create the index
> definition!  In the "Information Editor", first define your index, then
> click "Create File", and be sure to select "Description" and "Index
> Only".  The resulting DES file can be passed to BUTIL!

>  Goldstar Software Inc.
>  Building on Btrieve(R) for the Future(SM)
>  Bill Bach (From Washington, DC)

>  http://www.goldstarsoftware.com
>  *** Pervasive.SQL Service & Support Classes ***
>  Chicago, Washington DC - See our web site for details!



Sun, 13 Nov 2005 00:28:13 GMT
 BUTIL -INDEX
Actually, you need to use this one:
    BUTIL -SINDEX <sourceFile> <descriptionFile> [keyNumber]
Where <sourceFile> is your data file, <descriptionFile> is your DES file, and the optional
keyNumber is the key you want to have.
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach

 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago: May 12-16: See our web site for details!
Quote:

> So the usage would be:

> BUTIL -INDEX <databasefile.DAT> <INDEX FILE???> <descriptionfile.DES>

> What exactly goes in the <INDEX FILE> spot?

> Thank you so much for your help, Bill!


> > Yes, you can.  In fact, this is how the "Rebuild Utility" offers better
> > rebuild speeds than BUTIL.  The description file is defined in the
> > Pervasive manuals, so this is the best place to go.  You can either write
> > a program to use the Btrieve "Create Index" function, which requires a
> > specific data buffer, or you can use the BUTIL utility and provide a
> > description file.

> > One shortcut:  Use the GUI-based Maintenance Utility to create the index
> > definition!  In the "Information Editor", first define your index, then
> > click "Create File", and be sure to select "Description" and "Index
> > Only".  The resulting DES file can be passed to BUTIL!

> >  Goldstar Software Inc.
> >  Building on Btrieve(R) for the Future(SM)
> >  Bill Bach (From Washington, DC)

> >  http://www.goldstarsoftware.com
> >  *** Pervasive.SQL Service & Support Classes ***
> >  Chicago, Washington DC - See our web site for details!



Wed, 16 Nov 2005 12:07:10 GMT
 BUTIL -INDEX
Perfect!  Thanks so much for the help.
Quote:

> Actually, you need to use this one:
>     BUTIL -SINDEX <sourceFile> <descriptionFile> [keyNumber]
> Where <sourceFile> is your data file, <descriptionFile> is your DES file, and the optional
> keyNumber is the key you want to have.
>  Goldstar Software Inc.
>  Building on Btrieve(R) for the Future(SM)
>  Bill Bach

>  http://www.goldstarsoftware.com
>  *** Pervasive.SQL Service & Support Classes ***
>  Chicago: May 12-16: See our web site for details!



Fri, 18 Nov 2005 21:46:55 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. windows 2000 server and DOS butil

2. butil.exe error on win2k machine

3. Newbie: BUTIL and VB

4. butil

5. BUTIL description file format

6. BUTIL and Counting Records

7. Butil doesn't create all *.^^^ for *.dat

8. ascii export and import using butil

9. I need BUTIL.EXE for DOS

10. butil -stat and corrupt files

11. Problem with - butil -stat xxx.btr

12. windows 2000 server and DOS butil / ERROR


 
Powered by phpBB® Forum Software