[Seaside] GOODS speed

[Sebastián Sastre]

Try indexing the objects by the attribute you want optimized, by storing
them in a TSTree or a Btree that you store in the odb like this:

	tree at: each attributeNeededToBeAccessedQuikly put: each

	regards,

Sebastián Sastre
 
ssastre at seaswork.com.ar 
Seaswork 
Special Software Solutions
www.seaswork.com.ar


> -----Mensaje original-----
> De: seaside-bounces at lists.squeakfoundation.org 
> [mailto:seaside-bounces at lists.squeakfoundation.org] En nombre 
> de Benjamin Pollack
> Enviado el: Martes, 14 de Diciembre de 2004 15:40
> Para: The Squeak Enterprise Aubergines Server - general discussion.
> Asunto: [Seaside] GOODS speed
> 
> 
> I'm about to post an updated fulltext search package to 
> SqueakMap, but in the process of testing it, I've been a bit 
> underwhelmed by GOODS' performance. I built a sample database 
> on 2 MB of emails. Committing the indices to GOODS takes 
> several minutes, and once they've been committed, running a 
> search on them takes about 750 ms. In comparison, actually 
> building the indices takes only 30 seconds, and doing the 
> search in-memory takes about 1 ms. A similar query in 
> PostgreSQL on a far larger dataset executes in 50 ms, for 
> comparison. Are these performance times typical? If not, what 
> can I do to make them run more quickly?
> 
> Thanks.
> 
> --Benjamin
> _______________________________________________
> Seaside mailing list
> Seaside at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/listinfo/seaside
>