SQL feedback

[javapenguin]

Does SQL server give feedback about the progress so it is will be possible to reflect or bind it with the progress bar?

[cold_fusion]

Maybe but not sure of it.

Another trick is to retrieve first all primary keys (ID) of the resulting query.
Then retrieve/update again the data basing on the ID set one by one thus can be bound to a progress bar.
This is what MsAccess does for ODBC tables when updating, retrieving and showing data on screen.
This way also one can paginate thus making display faster.

[MarkCuering]

you want to have a progress bar (WinForm) while retrieving/updating large datas?

[javapenguin]

Maybe but not sure of it.

Another trick is to retrieve first all primary keys (ID) of the resulting query.
Then retrieve/update again the data basing on the ID set one by one thus can be bound to a progress bar.
This is what MsAccess does for ODBC tables when updating, retrieving and showing data on screen.
This way also one can paginate thus making display faster.

This sounds like a good idea, but I will be making more network traffic by reading twice, well I guess there will always be performance penalty when adding more features like a progress bar.

[javapenguin]

you want to have a progress bar (WinForm) while retrieving/updating large datas?

I need a cross platform solution preferably Java to retrieve large data and showing progress while reading database. The progress bar status will be synchronize with sql select,insert.....

[silent-kill]

if you mean return the current progress while the query is executing on sql server
- i think there is no way, if you notice in sqlserver management studio while you are doing some huge select statements the management studio doesnt really returns the current progress of sql server but rather just a 'preloader' type of progress bar with no current progress on it.

but if you mean display progress after the query has been executed and is now ready to return the
results.


heres what i usually do

I get the total count of resulting query

then do some

while (reader.read())
{
record++
 if(CurrentTickCountFunction() > tickcount + 1000)
 {
   tickcount = CurrentTickCountFunction()
   UpdateProgressBar(record)
 } 
  ... do some stuff
}
UpdateProgressBar(record)

so basically the code will update the progress bar every 1 second (or what ever you like) while you are still reading the record.
i prefer doing the tickcount technique rather than some modulo solution because it will always be constant on every computer regardless of its processing power.


if you wont be able to get the total count, then you should consider a different progress bar where it displays the total record reads-to-Unknown

usually i create the UpdateProgressBar() function as a delegate/ event so the form
using your class can subscribe to that event

below is a tool i created to upload images to Imageshack servers, which displays the current progress but its in c#
RapidShare Webhosting + Webspace

similar concept: Big Data + progress bar

[javapenguin]

if you mean return the current progress while the query is executing on sql server

This is what I mean, I know it is not possible, I just want to confirm coz I know you guys are smarter than me

[kibotizer]

nice one silent kill...


yeah! bling bling men...abz'

[dlanyer77]

@javapenguin

bro, database has nothing to do with the progress status. all you need is to play it on the codes.

[javapenguin]

@javapenguin

bro, database has nothing to do with the progress status. all you need is to play it on the codes.

so it is not possible to synchronize progress bar with database activity? I think cold_fusions suggestion is the nearest possible solution.