Re: Changing db structures?

2010-04-11 Thread Alexander Burger
On Sat, Apr 10, 2010 at 09:18:40PM +0200, Henrik Sarvell wrote: This can't be right, I must've meant (rebuild 29 'article '+ArFeLink) ? Right, first the attribute and then the entity. Sorry I didn't notice. Cheers, - Alex -- UNSUBSCRIBE: mailto:picol...@software-lab.de?subject=unsubscribe

Re: Scaling issue

2010-04-11 Thread Alexander Burger
Hi Henrik, (class +ArFeLink +Entity) (rel article (+Aux +Ref +Link) (feed) NIL (+Article)) (rel feed (+Ref +Link) NIL (+Feed)) (collect 'feed '+ArFeLink Obj Obj 'article) takes forever (2 mins) I need it to take something like maximum 2 seconds... Can this be fixed by adding some

Re: Scaling issue

2010-04-11 Thread Henrik Sarvell
I see, I should've known about that one (I'm using it to get similar articles already). What's additionally needed is: 1.) Calculating total count somehow without retrieving all articles. 2.) Somehow sorting by date so I get say the 25 first articles. If those two can also be achieved in a

Re: Scaling issue

2010-04-11 Thread Alexander Burger
On Sun, Apr 11, 2010 at 12:25:42PM +0200, Henrik Sarvell wrote: What's additionally needed is: 1.) Calculating total count somehow without retrieving all articles. If it is simply the count of all articles in the DB, you can get it directly from a '+Key' or '+Ref' index. I don't quite

Re: Scaling issue

2010-04-11 Thread Henrik Sarvell
Thanks Alex, I will go for the the reversed range and check out select/3. I'm already using collect with dates extensively but in this case it wouldn't work as I need the 25 newest regardless of exactly when they were published. /Henrik On Sun, Apr 11, 2010 at 1:27 PM, Alexander Burger

Re: Scaling issue

2010-04-11 Thread Alexander Burger
On Sun, Apr 11, 2010 at 02:19:23PM +0200, Henrik Sarvell wrote: Thanks Alex, I will go for the the reversed range and check out select/3. Let me mention that since picoLisp-3.0.1 we have a separate documentation of 'select/3', in doc/select.html. -- UNSUBSCRIBE: