[V4WS] question on deleting records

[Ruslan Zasukhin]

on 3/15/03 12:36 PM, Luca Porfiri at liste at mail.sting.it wrote:

>> Well, DeleteAll should be faster in theory.
>> 
>> If you have so big db of important data, I hope you do backups.
>> So after backup you can try DeleteAll for single cursor.
>> 
>> You need this operation only once?
> 
> No. I wish to "update" db adding data of today and deleting data of 3 months
> ago. So every day, if possible, I wish to execute this task automatically.
> In this way I will have a back-up db with all records but I will publish
> also a smart and very fast db with data since 3 months ago to today and the
> user will choose if he wishes to query the old db or recent one.
> One field of records is "publication date" I will use to decide what and
> when delete.
> 
> Now I fear for indexes. I have not done a test since now, but I read some
> threads on list and it seems very slow deleting indexed records. Every time
> I delete a record the process involves indexes also and it has to delete its
> words in index. So, this seems very slow, much more then add a record and,
> so doing, update index also, isn't it?
> I could try to delete a record or more records removing index flag for the
> fields in baseobject; so deleting will be very fast but then I will have to
> reindex all records!
> I hope to be wrong.

Again,

    curs.Add() and Curs.Delete()

Must take comparable time!

Both this operations do alsmot the same work with indexes.
So I do not see any reason why delete must be slower of Add()

If this is what you see in real life...then looks to be considered as
problem which must be optimized.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------