Re: Index and Deleted
From: Anders Eriksson (anders.eriksson_at_morateknikutveckling.se)
Date: 01/25/05
- Next message: Brendan Reynolds: "Re: How to Mimic Access' Externally Linked Tables using ADO?"
- Previous message: Al Dunbar [MS-MVP]: "Re: Visual Basic: Importing MS Excel data to MS Access"
- In reply to: Stephen Howe: "Re: Index and Deleted"
- Next in thread: Stephen Howe: "Re: Index and Deleted"
- Reply: Stephen Howe: "Re: Index and Deleted"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 Jan 2005 08:00:07 +0100
Hello Stephen!
On Mon, 24 Jan 2005 17:46:29 -0000, Stephen Howe wrote:
> If you delete a record, it does not really go, it remains and can be
> undeleted.
> It is similar to Access in the deleted sense and it takes a Compacting
> operation for Access to recover the disk space.
> IIRC (and I have not used dBASE since 1987), dBase has an equivalent
> concept of PACKing which really removes records. Your application should be
> such that that before terminating a connection, if you know you have deleted
> records from the database, it should PACKed. Do this and I am sure your
> performance will come back.
My problem is that there are multiple users of the database and you need to
open the database exclusive to be able to PACK it.
the visual dBase application retrieves records faster when there are
deleted records in the database.
I fail to see the logic in that ADO will get slower because of deleted
records. Doesn't it use the indexes to get the records?
// Anders
- Next message: Brendan Reynolds: "Re: How to Mimic Access' Externally Linked Tables using ADO?"
- Previous message: Al Dunbar [MS-MVP]: "Re: Visual Basic: Importing MS Excel data to MS Access"
- In reply to: Stephen Howe: "Re: Index and Deleted"
- Next in thread: Stephen Howe: "Re: Index and Deleted"
- Reply: Stephen Howe: "Re: Index and Deleted"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
