Program hang at database.close

[Neal Campbell]

See below

On Wed, Apr 16, 2008 at 1:09 PM, Ruslan Zasukhin
<sunshine at public.kherson.ua> wrote:
> On 4/16/08 7:08 PM, "Neal Campbell" <nealk3nc at gmail.com> wrote:
>
>  Hi Neal,
>
>
>  > I am using the "classes" method in my Realbasic project on Leopard
>  > 10.5.2 and am using Val 3.5.2. I am (I believe) successfully adding
>  > records to two tables in the database but when I execute the
>  > database.close routine the program goes "unresponsive" and gobbles up
>  > great deals of CPU resource and it never comes out of it. If I do a
>  > force quit, it can take quite a while for it to actually terminate (5
>  > minutes on occasion).
>
>
>
>  > Any clues as to how to isolate the problem? The warning log lists a
>  > bunch of segmentsize remaps (I have the cluster segment set at 64K on
>  > database creation).
>
>  Hmm
>
>
>  > I execute a flush of the database prior to the
>  > close and the log file indicates that went successfully.
>
>  1) so your app build quite big db I think, yes?
>     near to 1GB ?

Finder says the dat file is 8GB but thats close to impossible given
the expected population of data. I used to use a ram-based RealSQLDB
for it with no issues or excessive memory usage.  One table should
have about 360 row with 8 columns of strings at 40 bytes each. The
other table has 3500 rows with 4 columns of 40 bytes each. When I
bring it up in Studio it does not show any data, and if I try a
compact, etc, Studio also hangs.

I am trying the API way and at this moment assume its my bug but will
let you know. If I cannot find it, I will send you the program.

Thanks
Neal
>
>  2) app can be sent to us for testing?

>
>
>  --
>  Best regards,
>
>  Ruslan Zasukhin
>  VP Engineering and New Technology
>  Paradigma Software, Inc
>
>  Valentina - Joining Worlds of Information
>  http://www.paradigmasoft.com
>
>  [I feel the need: the need for speed]
>
>
>  _______________________________________________
>  Valentina mailing list
>  Valentina at lists.macserve.net
>  http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
Neal Campbell
Abroham Neal Software
Programming Services for Windows, OS X and Linux
(540) 242 0911
---------------------------------------------------------------------
Try Spot for OS X, the intelligent DXCluster Client at
www.abrohamnealsoftware.com

For a great dog book, visit www.abrohamneal.com