dbTalk Databases Forums  

create index (8.x)

comp.databases.btrieve comp.databases.btrieve


Discuss create index (8.x) in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
nmm
 
Posts: n/a

Default create index (8.x) - 01-26-2005 , 02:48 AM






Hi, a very simple question:
if one create (internal) indices at a time, when the file in question is used
from another workstation (record locks, record updates, inserts etc), can this
lead to any troubble? Or is "create index" allowed at any time?

Regards
Mircea

Reply With Quote
  #2  
Old   
Leonard
 
Posts: n/a

Default Re: create index (8.x) - 01-27-2005 , 08:32 AM






My experience is that it can be done "at any time" even while the file
is in use. However I have not personally done it while records were
locked so I do not know if that would cause issues.

There is a bit of overhead doing that and that index can not be
accessed until it is finished.

Leonard

On Wed, 26 Jan 2005 09:48:38 +0100, nmm
<Mircea.Malarski (AT) onlinehome (DOT) de> wrote:

Quote:
Hi, a very simple question:
if one create (internal) indices at a time, when the file in question is used
from another workstation (record locks, record updates, inserts etc), can this
lead to any troubble? Or is "create index" allowed at any time?

Regards
Mircea


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.