sql query in real time...ajax?

mattdaddym · Apr 19, 2007

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.

George Ter-Saakov · Apr 19, 2007

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.

mattdaddym · Apr 19, 2007

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.

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.

Guest · Apr 19, 2007

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

loaded where?

If you want to see a status of the SELECT...FROM query, you cannot get
it.
I think, you can have a kind of animated gif to imitate that process.

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.

Maybe you may need to think about paging? A more efficient way to
handle this is to use SQL Server (a server-side cursor, or can be
implemented using a SQL Server stored procedure)

mattdaddym · Apr 22, 2007

Thanks for your response. There are some cases, like when my users are
exporting a report to excel that it would be cool to show them exactly
how much time and/or rows are left. So, if I bind a datasource to a
datatable, I cannot use client-side AJAX type code to read how many
rows have been added to the datatable?

I honestly don't know much about how this mechanism works, but I
thought the rows were added as they are received.

Guest · Apr 22, 2007

exporting a report to excel that it would be cool to show them exactly
how much time and/or rows are left. So, if I bind a datasource to a

In this case, I think, you offer a download the file (an export).
Make a page in between as follows. It will show a "status" of the
export.

Replace the "ExportToExcel.aspx" to a name of your export page.

----------------------------------------------------------------------------------------------------------
<%@ Page Language="vb" %>
<HTML>
<HEAD>
<script language="javascript">

var iLoopCounter = 1;
var iMaxLoop = 5;
var iIntervalId;

function BeginPageLoad() {
location.href = "ExportToExcel.aspx";
iIntervalId =
window.setInterval("iLoopCounter=UpdateProgress(iLoopCounter,
iMaxLoop)", 500);
}

function EndPageLoad() {
window.clearInterval(iIntervalId);
Progress.innerText = "Page Loaded -- Not Transferring";
}

function UpdateProgress(iCurrentLoopCounter, iMaximumLoops) {

iCurrentLoopCounter += 1;

if (iCurrentLoopCounter <= iMaximumLoops) {
Progress.innerText += ".";
return iCurrentLoopCounter;
}
else {
Progress.innerText = "";
return 1;
}
}
</script>
</HEAD>
<body onload="BeginPageLoad()" onunload="EndPageLoad()">
Loading - Please Wait</span> <span id="Progress"></span>
</body>
</HTML>

markman954 · Apr 22, 2007

In this case, I think, you offer a download the file (an export).
Make a page in between as follows. It will show a "status" of the
export.

Replace the "ExportToExcel.aspx" to a name of your export page.

----------------------------------------------------------------------------------------------------------
<%@ Page Language="vb" %>
<HTML>
<HEAD>
<script language="javascript">

var iLoopCounter = 1;
var iMaxLoop = 5;
var iIntervalId;

function BeginPageLoad() {
location.href = "ExportToExcel.aspx";
iIntervalId =
window.setInterval("iLoopCounter=UpdateProgress(iLoopCounter,
iMaxLoop)", 500);

}

function EndPageLoad() {
window.clearInterval(iIntervalId);
Progress.innerText = "Page Loaded -- Not Transferring";

}

function UpdateProgress(iCurrentLoopCounter, iMaximumLoops) {

iCurrentLoopCounter += 1;

if (iCurrentLoopCounter <= iMaximumLoops) {
Progress.innerText += ".";
return iCurrentLoopCounter;
}
else {
Progress.innerText = "";
return 1;
}}

</script>
</HEAD>
<body onload="BeginPageLoad()" onunload="EndPageLoad()">
Loading - Please Wait</span> <span id="Progress"></span>
</body>
</HTML>

Cool beans, I'll give it a shot. Thanks.

Survey details won't go through using php, ajax, Mysql	0	Oct 26, 2023
Monitoring SQL query packets in real time	2	Jun 1, 2005
Sql query	6	Jul 15, 2009
Checking dynamically populated data using ajax with user entered value	5	Apr 11, 2020
SQL Query	4	Jul 7, 2007
Real-time database monitor	5	May 8, 2008
problem with sqlite3: cannot use < in a SQL query with (?)	22	Jan 23, 2014
International datetime comparisons in real-time web apps	1	Jul 9, 2009

sql query in real time...ajax?

mattdaddym

George Ter-Saakov

mattdaddym

Guest

mattdaddym

Guest

markman954

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads