I almost forgot, I think I am seeing +Aux relations in no 1 too, fairly long lists of dotted pairs smells like it. I suppose my dbs example in the prior post won't take care of them properly, ie putting them in their own files?
/Henrik On Tue, Aug 18, 2009 at 8:49 PM, Henrik Sarvell<[email protected]> wrote: > I had messed up, I'm OK now, the list to dbs was not in the proper shape. > > Anyway no 1 is still growing big, what I've done here is to try and > emulate the er file in the app demo. In that er file no non-ref/key > relation is mapped anywhere in the call to dbs, why? > > I've just started stepping through file no 1 and I see that the > +WordCount references are there, this is my dbs call: > > (dbs > =A0 (2 +User +Feed) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 # 1 > =A0 (3 +Article +ArticleLinks) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0# 2 > =A0 (3 +Aword +Awords) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0# 3 > =A0 (2 +Tag +FeedTag) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 # 4 > =A0 (3 +Read +Likes +ArticleTag) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0#= 5 > =A0 (4 +WordCount +Similarity) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0# 6 <------- > =A0 (2 (+User uname uid feeds)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 #= 7 > =A0 (3 (+Feed fid xmlUrl htmlUrl)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0# 8 > =A0 (3 (+Article aid htmlUrl picoDate feed words)) =A0# 9 > =A0 (3 (+ArticleLinks from to)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 #= 10 > =A0 (3 (+Aword word)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 # 11 > =A0 (3 (+WordCount word article)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 # 1= 2 <-------- > =A0 (3 (+Similarity a1 a2)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 # 13 > =A0 (3 (+Tag tag)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0# 14 > =A0 (3 (+FeedTag user tag feed)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0#= 15 > =A0 (4 (+ArticleTag user tag article)) =A0 =A0 =A0 =A0 =A0 =A0 =A0# 16 > =A0 (3 (+Likes user article)) =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= # 17 > =A0 (3 (+Read user article))) > > And the +WordCount definition looks like this: > > (class +WordCount +Entity) # > (rel word =A0 =A0 =A0(+Aux +Ref +Link) (article) NIL (+Aword)) # > (rel article =A0 (+Ref +Link) NIL (+Article)) # > (rel count =A0 =A0 (+Number)) > > Note how the count +Number is missing from the dbs mapping, could that > fact have anything to do with it? > > Anyway, this is a couple of examples of what it looks like when I'm > stepping no 1: > > {;2} (+WordCount) > =A0 count 1 > =A0 article {2-1} > =A0 word {3-34} > (seq Obj) > ! > {;3} (+WordCount) > =A0 count 1 > =A0 article {2-1} > =A0 word {3-35} > (seq Obj) > ! > {;4} (+WordCount) > =A0 count 1 > =A0 article {2-1} > =A0 word {3-36} > (seq Obj) > > Any ideas of why the counts end up in no 1? > > /Henrik > > > On Tue, Aug 18, 2009 at 9:08 AM, Henrik Sarvell<[email protected]> wrote= : >> Thanks for that, will try it out tonight! >> >> /Henrik >> >> >> On Tue, Aug 18, 2009 at 7:21 AM, Alexander Burger<[email protected]> w= rote: >>> Hi Henrik, >>> >>>> I've just used dbs to split my database into several files which seems >>>> to be working but if I recall correctly the catch all will be file no >>>> 1 and it's growing out of proportion very rapidly when I import my >>>> data. Out of proportion with regards to what I believe should be in it >>>> that is. >>> >>> The first thing I would do is load "lib/too.l" and then call (dbfCheck)=
