Re: Progress bar for database query

Thanks Philippe,


> On Thu, Oct 15, 2015 at 2:23 PM, [email protected]
> <[email protected]> wrote:
>> 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?
> 
> This is quite tricky, I would rather try to speed up the database query ;-)

	In any case, when the data to elaborate is very big, i have the problem.
> 
> First there's the question of how you get the progress of the query
> itself. If you don't know in advance how may rows you expect or it's a
> query that doesn't return a result (like an update) this can get
> tricky. You could try to run and parse an EXPLAIN to get a guesstimate
> of how many rows you will get. Or some databases allow you to check to
> progress of a query in a different session.
> Then there's the question of sending the progress updates to the
> client. If you're on Zinc you can use it's WebSockets support. If
> you're not and your sever adaptor supports flushing you can try to
> implement Sever Sent Events.

	I don't need to display the progress bar status of the elaborations.

	I wrong my request.

	I need to display the 'elaborations - processing' ,

		that processing is in progress on the server.

	Something that informs the user about the processing on the server until the answer. 

	Without informations about the specific progress of processing.





	I hope to explained well.

	Thanks,

		Dario

_______________________________________________
seaside mailing list
[email protected]
http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside