Re: Index and Deleted

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 17:46:29 -0000

> If the records IS NOT deleted it will take men 1 second to open a
recordset
> and read the first record in the recordset.
>
> If the records ARE deleted the same operation will take 350 seconds
>
> The database contained 25000 records (140MB).
>
> Anyone that understand why there is this difference in time??

I understand what goes on but not the difference in time. No doubt someone
can enlighten me as to why deleted records make this difference.

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.
I am not sure how you do this, but 5 minutes with Google will tell me the
answer.

Hope this helps

Stephen Howe

Relevant Pages

  • Re: limitation on string of 255 bytes???
    ... recall. ... IIRC, this dates from ... dBASE II. ... He/She has prejudices. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: DatEase v4.53. Can I export the data to Acess?
    ... Well, it's been more than 15 years since I used DataEase, but IIRC the file ... format was dBase 4. ... tables with the dBase filter. ...
    (microsoft.public.access.externaldata)
  • set gv from 1st rec in dbase5
    ... I have a loop to bring in about 30 dbase tables into sql. ... I would like to capture 2 values from the first record in a certain table to set a global variable so that I can use that global variable to fill in some columns in other tables. ...
    (microsoft.public.sqlserver.dts)
  • Re: Unique File name
    ... >I think it only goes back to dBase III. IIRC, ... >workareas called Primary and Secondary. ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)