Hi All

I have the following MySQL Function that I use to copy my Product table from the Server to the Local System's database


Does anyone know how I can show a ETA on the screen (example Processing Record 1  of  12,999 & " Reaming to Process 12,998 (ETA 05:00 Mins)

or could someone point me in the direction so I can read up on how to show a Est time remaining

I was working on 2 seconds a record so that would be 12999 *2 = 25,998 then divide by 60 (minute) = 433.3 would that be mins or hours ?

The theory is that in data processes that take a long time, there can be many factors that will effect the actual time taken.
The source(Server)  or recipient(Workstation), may have other background tasks that can take up cycle time and so your
solution for an ETC (Estimated time of completion) needs to be self adjusting.


START = Now() 'Get the start time.
Read a set number of records                                             ' say 2 records ?
END = Now()
DURATION = DateDiff(START,END,Gb.Second)                'Record how long this takes in seconds - you could change to Gb.Milliseconds to suit?

ETC = DURATION * Records Remaining                            'In seconds

Update Progress bar with records read and ETC converted to readable time.

That's the theory anyway…

 Hi Quincunxian

Thank you for that example I will see what I can can come up with

if i have something say like 56,003 seconds how would i convert that into minutes so I could display it on screen

 You need to understand query planning.
For each query you send to the database it has to a) parse the query and formulate the most efficient approach, b) process the query and c) output a response. Around this wrap the latency due to network/other processes being scheduled etc. so

1. Updating the local database record by record is the most inefficient way to do this possibly imaginable as a) and c) are repeated each time
2. Basing a guestimate on one or two records will be inaccurate as in that case a) can sometimes be the major "cost" of the entire transaction.

thatbruce

AndyGable said

Hi Quincunxian

Thank you for that example I will see what I can can come up with

if i have something say like 56,003 seconds how would i convert that into minutes so I could display it on screen

you can use \ and % operators
\ gives the division without the remainder
% gives the remainder

the following will give a string like 15h33m23s for the 56003 seconds and omit showing any zero numbers

BruceSteers said

AndyGable said

Hi Quincunxian

Thank you for that example I will see what I can can come up with

if i have something say like 56,003 seconds how would i convert that into minutes so I could display it on screen

you can use \ and $ operators
\ gives the division without the remainder
% gives the remainder

the following will give a string like 15h33m23s for the 56003 seconds and omit showing any zero numbers

Code (gambas)

1.  
2. Public Sub SecsToMins(iSecs As Integer) As String
3.  
4.   Dim h, m, s As Integer, sStr As String
5.  
6.   m = iSecs \ 60
7.   s = iSecs % 60
8.  
9.   If m >= 60 Then
10.     h = m \ 60
11.     m = m % 60
12.   Endif
13.  
14.   If h Then sStr = h & "h"
15.   If m Then sStr &= m & "m"
16.   If s Then sStr &= s & "s"
17.   Return sStr
18.  
19. End
20.  
21.  

Bruce that was just what I needed
<IMG src="https://www.algpos.co.uk/webimage/DataSyncScreenShot.png"> </IMG>

I know this is not fully accuate but it is just a guide and it works great thanks

AndyGable said

if i have something say like 56,003 seconds how would i convert that into minutes so I could display it on screen

Here is an alternative way: