Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I need to go trough log files and calculate the time a query takes to finish.
I have three columns
Date , Hour, Query
2020.04.02 / 07:00:00 / BLABLA
2020.04.02 / 07:01:00 / SQL Select
2020.04.02 / 07:01:02 / BLABLA
2020.04.02 / 07:01:03 / BLABLA
2020.04.02 / 07:01:04 / 30 Fields Found
In the column Query i have the data.
I need to loop trough every row with a condition.
The condition is : Start loop when you find "Sql Select" and finish loop when you find "Fields Found" then go to the next "Sql Select"
After i need to calculate the time of execution so ( HOUR of Field Found - HOUR of Sql select)
Can you help me ? Thank you.