corrupted databases - we need a tool!

[Ruslan Zasukhin]

On 10/5/04 1:31 AM, "michael geary" <listmail at gearyweb.com> wrote:

Hi Michael,

> I am a big fan of Valentina, and as long as things go smoothly, I don't
> have any problems. BUT, I think we need some tools to repair/rebuild
> databases when they go bad.
> 
> Using the Valentina App (OS X) I just deleted 1000000 records from a
> table, emptying it. I then closed the DB and tried to re-open it.
> Nothing. It is broken. Nothing I can do at all.

Bad. It looks that deletion of huge number of records can cause problems...

> The database is well over 300 MB, so it's not terribly practical for me
> to store an XML dump on a frequent basis. Fortunately, I'm not really
> losing any data with this corruption, because I can reconstruct the DB
> from other sources, but I am losing time.
> 
> This is not the first time this has happened. Not at all. When things
> are good, they are very good. But when things are bad, they are very
> bad.
> 
> Has anyone had similar experiences? I really wish I didn't have to go
> through this.

1) I think or 2.0 we will prepare very intensive tests like your.
To make sure it works correctly.


2) in Valentina 3.0 we plan add transactions. This is the most powerful way
of protection. 



-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------