Cache question/bug report?

[Ruslan Zasukhin]

on 7/16/03 0:29, jda at jda at his.com wrote:

Hi Jon,

> In my V4RB-based app, I have a rebuild option. All records are
> written to disk (in my own format), a new database is created, and
> the records are imported into that. It's much, much faster than
> export/import as XML and generally works well.

Hmm, you want to say that your import written in RB code and using V4RB
plugin works faster of my ASCII import/export ?!
I do not believe! :-)

> But now two different users have complained that their large database
> fail. The export/import goes well and the database seems fine. You
> can search, sort, etc.
> 
> BUT, once you close the db, if you try to reopen you get a -39 error.
> 
> I have one of these dbs and can reproduce the problem. It has about
> 3200 records (mostly text and blob) with LOTS of data (the db is
> about 23 MB).
> 
> After a lot of playing around, I find that if I increase the
> Valentina db cache to 50 MB (up from my standard of 20 MB)
> export/import now works!
> 
> Why might this be? Doesn't Valentina page out when the cache is filled?

No, Valentina do not page out.

Sounds like a bug in cache. In the past I have see such problems few times.

1) does that db have the same number of fields, but differ only by number of
records?

2) do you just import import import records with no flush?
If yes then you can try add flush after each, say 1000 or 5000 records.

-- 
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
-------------------------------------------------------------