[Glass] [Seaside] Progress bar for database query

[Trussardi Dario Romano via Glass]

Ciao Mariano,

	thanks for your considerations.

> Hi Dario,
> 
> It looks strange to me that a query to GemStone could take that much. Did you profile it?  how many rows has the collection? which type of collection is it?   the complexity / time goes into the "condition" rather in the select?
> I ask because many times I was in the same situation, after a quick profiling,
	
	I don't have experience into index.

> I noticed that adding an index would solve it.

	I defined my request as 'query'   but, i think,	it is not a query on possible indexed data.

	My query is relative to the some dictionaries ( one dictionary for any day ) everyone with a dictionary about the documents ( 200 - 300 )  managed on the day.

	Every document is based on a bag of items ecc.  ecc.. ecc...

	With my surprise when i have 2 - 3 moths on-line all works fine.  ( the SPC is set to 2097152 )

	But now when i have 6 months on-line the system answer with some delay.

	My goal for now is to have online 12 months.

	I need to change  my internal structure ?

	Cheers,
			
		Dario

	

> 
> Cheers,
>  
> 
> ---------- Forwarded message ----------
> From: dtrussardi at tiscali.it <dtrussardi at tiscali.it>
> Date: Thu, Oct 15, 2015 at 9:23 AM
> Subject: [Seaside] Progress bar for database query
> To: seaside-wiki <seaside at lists.squeakfoundation.org>
> 
> 
> Ciao,
> 
>         i have a seaside application with some user interface.
> 
>         Now i have one specific user request for query the database.
> 
>         This request required some long time on the server before answer.
> 
>         My goal is to :
> 
>                 a) display a progress bar when the user submit this query
> 
>                 b)  block the web user request until the server answer the data query result
> 
> 
>         How i can implemented this solution?
> 
>         Thank for any considerations.
> 
> 
>                 Dario
> 
>         _______________________________________________
> seaside mailing list
> seaside at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> 
> 
> 
> -- 
> Mariano
> http://marianopeck.wordpress.com
> _______________________________________________
> Glass mailing list
> Glass at lists.gemtalksystems.com
> http://lists.gemtalksystems.com/mailman/listinfo/glass

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gemtalksystems.com/mailman/private/glass/attachments/20151015/4307749c/attachment.html>