Fwd: Program hang at database.close

[Neal Campbell]

Hi again

 I just send the source  and data files in a separate email as this is
 going to be a commercial project and I didn't want it on the
 reflector!

 I migrated it with the API style instead of the class style and the
 results seem the same except it also hangs on a table flush command.
 Ignore any nasty RB coding I was just whipping it together so I could
 see what was happening better in the debugger. I will stick with the
 API style for the program as it follows the documentation and makes
 the documentation more meaningful.

 Neal



 On Wed, Apr 16, 2008 at 3:19 PM, Ruslan Zasukhin

<sunshine at public.kherson.ua> wrote:


> On 4/16/08 8:36 PM, "Neal Campbell" <nealk3nc at gmail.com> wrote:
 >
 >  >>> 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.
 >
 >  Two points:
 >
 >  1) while you are Valentina beginner, try to not change default settings.
 >     so please return back  db.SegmentSize to 32Kb
 >
 >  2) I think problem come from your code with CLASSES.
 >
 >
 >  Please paste it here,
 >     and/or take careful look on V4RB/Examples/CLASSES
 >     and/or send to us your test project
 >
 >
 >
 >  --
 >
 >
 > 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



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