Inconsistent database behaviour using RealBasic andValentinaon WinXP, MacOS, MacOSX

[Richard Bundock]

Ruslan

Now I feel stupid for not checking the memory limit... I found the settings
for memory in RealBasic and changed them. IT WORKS... hooray, now I just
have to pick up all the hair I pulled out my head trying to figure this out.

Many thanks

Rich

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: 11 December 2003 17:13
To: valentina at lists.macserve.net
Subject: Re: Inconsistent database behaviour using RealBasic
andValentinaon WinXP, MacOS, MacOSX


on 12/11/03 6:31 PM, Richard Bundock at rbundock at bluementor.com wrote:

> Cindy, Ruslan
>
> Ive tried deleting the ind file and letting Valentina rebuild it - this
> didnt work.
>
> Below is a breakdown of my database (-> denotes pointers):
>
> Company            [70,111 records]
> Film               [356,350 records]
> FilmName           [519,955 records]
>   -> Film
> Join_Company       [338,896 records]
>   -> Company
>   -> Film
> Join_Person        [2,052,408 records]
>   -> Film
>   -> Person
> JoinLit            [41,450 records]
>   -> LitSource
>   -> Person
> JoinName_Company   [523,719 records]
>   -> Company
>   -> FilmName
> JoinName_Person    [4,527,493 records]
>   -> FilmName
>   -> PersonName
> LitSource          [37,125 records]
>   -> Film
> Origin             [371,827 records]
>   -> Film
> Person             [439,897 records]
> PersonName         [464,337 records]
>   -> Person
> Reference          [303,191 records]
>   -> Film

Well, you have big enough database...

> It seems that some tables are fine, however others when queried even with
> something simple like
>
> SELECT COUNT(*) FROM Person
>
> Cause the database to fail on the Mac OS9 build only.

What means fail ?
Wrong result in reutrn?  Crash? Else?


> One guess is that
> something is wrong with the pointers between my Person table and the Join
> tables - although what that might be is proving elusive.

I don't think this is pointers, because your above COUNT(*) do not touch
pointers.


> Another guess is
> that I may have reached some kind of limit somewhere in terms of size.

Also probably no.

> The
> database works fine on Mac OS9 if I only use a small subset of the data
(eg.
> 10,000 records max in each table).

May be you have too small database cache?!
What its size?

Make sure you have e,g, 10-12MB cache.

Aha!

Another OLD and probably forget by many issue.

MacOS 9 assign to application STRICT limit on RAM.
When you compile your app in RB you must assign at least 20MB total for app.
Otherwise you can get e.g. 6MB and cache will be in the best case 2-3 MB.

Check this point.

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

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003