[Seaside] Progress bar for database query
dtrussardi at tiscali.it
dtrussardi at tiscali.it
Thu Oct 15 13:11:04 UTC 2015
Thanks Philippe,
> On Thu, Oct 15, 2015 at 2:23 PM, dtrussardi at tiscali.it
> <dtrussardi at tiscali.it> 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
-------------- next part --------------
Skipped content of type multipart/related
More information about the seaside
mailing list