Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

[WE] Long response page? (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: RE: Multi-tasking/Multi-threading (was How do I handle a "PleaseWait"window?)
Next thread: Set the file comments using AppleScript (under Lion)


Re: Backward to 2011r3 from Xojo   -   Garth Hjelte
  [WE] Long response page?   -   Darryl Snover
   Re: [WE] Long response page?   -   Norman Palardy
   Re: [WE] Long response page?   -   Darryl Snover
   Re: [WE] Long response page?   -   Greg O'Lone

[WE] Long response page?
Date: 03.08.11 19:40 (Wed, 03 Aug 2011 14:40:48 -0400)
From: Darryl Snover
I'm hoping that someone has done something similar with WE. What I've got is a web app, running through Apache (https), which has as one of its views, a query window, with several pre-defined queries, which users have asked for. Normally, the app delivers the query results to a WebListBox, and then, if the results are what the user wants, they have the option to export them to csv format.

Most times, this works wonderfully. However, as users have become enamored with the ability to generate 'reports', they have also requested more complex queries, which sometimes generate large datasets. As is typically the case, problems have arisen whereby the data is larger than can be returned in a short amount of time. I have a web dialog that presents a 'processing' message with activity bar which disappears when the query is returned. However, in this case, the query doesn't return, as the timeout is apparently too long, and the session is disconnected, ultimately resulting in the circle with a line through it.

I'm open for ideas as to how I can effectively deal with this. In my 'WebObjects' days, we had a 'long response page' which was effective for dealing with this.

One thing I _am_ thinking of is to 'page' the results, such that the first X results are shown, and if the user wants more, they can click the 'next x rows' button. This seems to be effective, but may not resolve the CSV timeout for files.

Thoughts? Suggestions? Criticisms?

Thanks,

Darryl Snover





_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: [WE] Long response page?
Date: 04.08.11 02:24 (Wed, 3 Aug 2011 19:24:33 -0600)
From: Norman Palardy

On Aug 3, 2011, at 6:53 PM, Darryl Snover wrote:

> Hi Greg,
>
> I'm running REAL Studio 2011 Release 1.1, Enterprise Edition,
> connecting to OpenBase using the OpenBase Connectivity Module (from
> OpenBase). I'm fairly certain that the issue is with the amount of
> data returned, and the delay from running the query, to loading the
> listbox.

Ah
That module is entirely written in Real Studio so it should behave OK
in a thread if that helps at all

Norman Palardy

Real World 2012, THE Real Studio Event of the year!
http://realsoftware.com/community/realworld.php

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: [WE] Long response page?
Date: 04.08.11 01:53 (Wed, 03 Aug 2011 20:53:33 -0400)
From: Darryl Snover
Hi Greg,

I'm running REAL Studio 2011 Release 1.1, Enterprise Edition, connecting to OpenBase using the OpenBase Connectivity Module (from OpenBase). I'm fairly certain that the issue is with the amount of data returned, and the delay from running the query, to loading the listbox.

Thanks,

Darryl Snover

On Aug 3, 2011, at 6:42 PM, Greg O'Lone wrote:

> Can you tell us what version of Studio you are running and what type of database you are connecting to?
>
> Greg O'Lone
> Software Engineer
> Real Software, Inc.
> Real World 2012, THE Real Studio Event of the year!
>
> On Aug 3, 2011, at 2:40 PM, Darryl Snover wrote:
>
>> I'm hoping that someone has done something similar with WE. What I've got is a web app, running through Apache (https), which has as one of its views, a query window, with several pre-defined queries, which users have asked for. Normally, the app delivers the query results to a WebListBox, and then, if the results are what the user wants, they have the option to export them to csv format.
>>
>> Most times, this works wonderfully. However, as users have become enamored with the ability to generate 'reports', they have also requested more complex queries, which sometimes generate large datasets. As is typically the case, problems have arisen whereby the data is larger than can be returned in a short amount of time. I have a web dialog that presents a 'processing' message with activity bar which disappears when the query is returned. However, in this case, the query doesn't return, as the timeout is apparently too long, and the session is disconnected, ultimately resulting in the circle with a line through it.
>>
>> I'm open for ideas as to how I can effectively deal with this. In my 'WebObjects' days, we had a 'long response page' which was effective for dealing with this.
>>
>> One thing I _am_ thinking of is to 'page' the results, such that the first X results are shown, and if the user wants more, they can click the 'next x rows' button. This seems to be effective, but may not resolve the CSV timeout for files.
>>
>> Thoughts? Suggestions? Criticisms?
>>
>> Thanks,
>>
>> Darryl Snover

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: [WE] Long response page?
Date: 03.08.11 23:42 (Wed, 3 Aug 2011 18:42:15 -0400)
From: Greg O'Lone
Can you tell us what version of Studio you are running and what type of database you are connecting to?

Greg O'Lone
Software Engineer
Real Software, Inc.
Real World 2012, THE Real Studio Event of the year!

On Aug 3, 2011, at 2:40 PM, Darryl Snover wrote:

> I'm hoping that someone has done something similar with WE. What I've got is a web app, running through Apache (https), which has as one of its views, a query window, with several pre-defined queries, which users have asked for. Normally, the app delivers the query results to a WebListBox, and then, if the results are what the user wants, they have the option to export them to csv format.
>
> Most times, this works wonderfully. However, as users have become enamored with the ability to generate 'reports', they have also requested more complex queries, which sometimes generate large datasets. As is typically the case, problems have arisen whereby the data is larger than can be returned in a short amount of time. I have a web dialog that presents a 'processing' message with activity bar which disappears when the query is returned. However, in this case, the query doesn't return, as the timeout is apparently too long, and the session is disconnected, ultimately resulting in the circle with a line through it.
>
> I'm open for ideas as to how I can effectively deal with this. In my 'WebObjects' days, we had a 'long response page' which was effective for dealing with this.
>
> One thing I _am_ thinking of is to 'page' the results, such that the first X results are shown, and if the user wants more, they can click the 'next x rows' button. This seems to be effective, but may not resolve the CSV timeout for files.
>
> Thoughts? Suggestions? Criticisms?
>
> Thanks,
>
> Darryl Snover
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>