Re: sql query in real time...ajax?

On Apr 19, 1:15 pm, "George Ter-Saakov" <gt-...@xxxxxxxxxxx> wrote:
Sound like to much effort for something small.
So far all I saw is approximations.
Like we know that on average we get 100 rows per second so if you have 1000
records will be uploaded in 10 seconds.

If user gets lucky and it ends in 9 seconds then you finish your bar early
and user happy.
If not lucky then you simply push that indicator a little back.

You should be familiar with this approach if you ever tried to Copy/Delete a
lot of files in Windows.

George.

<mattdad...@xxxxxxxxx> wrote in message

news:1176999897.237315.167340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi all,

I'm looking for a way to show my users the progress of their sql
queries. I've implemented Microsoft Ajax in order to show a progress
bar, but I would love to be able to show:

number of rows loaded vs total rows

I tried a few searches for this, but haven't come up with the right
key words I guess. Right now I have zilch. So, it's easy enough to get
a count of the total rows before starting. I guess I need to query the
datasource every .5 to 1 second and display how many rows it has
retrieved already. This way the user has some idea how long the whole
thing is going to take.

Any ideas?

Thanks in advance.

Don't talk to me about Windows OS progress bars....lol.

I don't know...this seems like basically the same concept of a
download progress bar, except instead of file sizes we are looking at
a database query. Also, it is a lot of effort...the first time. After
that, it's gravy. Thanks for your time.

.

Relevant Pages

  • RE: Statusbar
    ... I see the progree bar happenening on the bottom of the screen. ... 'this updates the progress bar ont he first update progress box. ... Sub TestBar() ... StatBar i, MyTot, "Processing", True ' display statusbar ...
    (microsoft.public.excel.programming)
  • Re: VB6 Newbie - Progress Bar
    ... It looks like outside the sql, you have 3 for/next loops handling file ... It is during these that you would have to calculate the progress. ... greater than stuffing it in a file, so the bar would sit at 0 for a ... Dim tempRecSet As Recordset ...
    (microsoft.public.vb.general.discussion)
  • RE: Statusbar
    ... I do not have a Userform on this workbook atall. ... I see the progree bar happenening on the bottom of the screen. ... 'this updates the progress bar ont he first update progress box. ... Sub TestBar() ...
    (microsoft.public.excel.programming)
  • Re: Startup progress bar
    ... "Slobodan Brcin " wrote: ... You are saying you see the text mode progress bar instead of ... >> regular XP/XPe graphic logo progress screen? ... >> - How XP Pro works on the same device with the same CF card installed? ...
    (microsoft.public.windowsxp.embedded)
  • RE: Statusbar
    ... 'this updates the progress bar ont he first update progress box. ... With the code as it is, the status bar work fine, but the progress indicator ... Sub TestBar() ... StatBar i, MyTot, "Processing", True ' display statusbar ...
    (microsoft.public.excel.programming)