Board index » delphi » Pack/Reindex dbf files on a multi user environment

Shaqfu

Delphi Developer
Mon, 14 Nov 2005 18:43:05 GMT

Pack/Reindex dbf files on a multi user environment

I would like to find a way to perform a pack/reindex on dbf files in a
multi-user environment.  To my knowledge the dbf files must be opened in
exclusive mode for a pack/reindex to be performed.

How is it possible to run pack/reindex in a multi-user environment?
Is it possible to pack/reindex without opening the dbf files exclusively?
If users have some dbf files open is it possible to pack/reindex the files
while they are open?

I appreciate any help/ideas offered.

Thanks.

Shaq

 
Rick Roe

Delphi Developer
Tue, 15 Nov 2005 05:07:46 GMT

Re:Pack/Reindex dbf files on a multi user environment


There is no way that I know of the pack a Dbase table without exclusive
access.

You can try to write a program to pack a table or tables by first checking
to see if you can open exclusively.  Then you can pack the table.  If you
run this on some schedule, maybe at night, maybe the chances of another user
having the table open will decrease.

HTH

Rick

Quote
"Shaqfu" <s...@bike-fast.com> wrote in message

news:3ed5e516$1@newsgroups.borland.com...
Quote
> I would like to find a way to perform a pack/reindex on dbf files in a
> multi-user environment.  To my knowledge the dbf files must be opened in
> exclusive mode for a pack/reindex to be performed.

> How is it possible to run pack/reindex in a multi-user environment?
> Is it possible to pack/reindex without opening the dbf files exclusively?
> If users have some dbf files open is it possible to pack/reindex the files
> while they are open?

> I appreciate any help/ideas offered.

> Thanks.

> Shaq

Bill Tod

Delphi Developer
Tue, 15 Nov 2005 06:11:45 GMT

Re:Pack/Reindex dbf files on a multi user environment


Quote
>I would like to find a way to perform a pack/reindex on dbf files in a
>multi-user environment.  To my knowledge the dbf files must be opened in
>exclusive mode for a pack/reindex to be performed.

Your knowledge is correct. You will need to pack the tables at a time
when no one is using the system.

Quote

>How is it possible to run pack/reindex in a multi-user environment?

Multi-user or 7x24? In a multi-user environment you need to pack the
tables at night or during the weekend. If the application has to be
on-line 24 hours a day, 7 days a week the only solution is to change
databases.

Quote
>Is it possible to pack/reindex without opening the dbf files exclusively?
>If users have some dbf files open is it possible to pack/reindex the files
>while they are open?

No.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Shaqf

Delphi Developer
Tue, 15 Nov 2005 20:52:39 GMT

Re:Pack/Reindex dbf files on a multi user environment


This is a temporary solution before the jump to sql.  We are already in the
process of moving towards sql and we all know that it will solve the
problem.

We still need to support our current dbase application and I just wanted to
make sure there wasn't an alternative method to this problem.  I guess we
will just have to monitor the dbase files and once we get an exclusive lock
then we can pack/index or run it nightly as you all have suggested.

I appreciate all your help.

Thanks.

Shaq

Quote
"Bill Todd" <n...@no.com> wrote in message

news:n21ddvk7jejt7tgrj10jcnmrv8oeonfok3@4ax.com...
Quote
> >I would like to find a way to perform a pack/reindex on dbf files in a
> >multi-user environment.  To my knowledge the dbf files must be opened in
> >exclusive mode for a pack/reindex to be performed.

> Your knowledge is correct. You will need to pack the tables at a time
> when no one is using the system.

> >How is it possible to run pack/reindex in a multi-user environment?

> Multi-user or 7x24? In a multi-user environment you need to pack the
> tables at night or during the weekend. If the application has to be
> on-line 24 hours a day, 7 days a week the only solution is to change
> databases.

> >Is it possible to pack/reindex without opening the dbf files exclusively?
> >If users have some dbf files open is it possible to pack/reindex the
files
> >while they are open?

> No.

> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)

Other Threads

1. D1, dbf - refreshing grids in multi-instance (multi-user) case

2. Reindex dbf files

3. How to pack/reindex DBase3 files?

4. Non-maintained indices in a multi-user environment

5. Problem with Subset condition on Dbase table in multi user environment

6. Multi-User environment using Paradox with Delphi

7. Multi-user environment using databases

8. Multi-User environment problem

9. Problems posting in multi-user environment

10. ADO in Multi-User environment