RomRaider Logo

RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Tue Dec 23, 2025 8:49 am

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Logger "queries/sec" vs the spreadsheet "Time"
PostPosted: Sat Mar 11, 2023 9:09 am 
Offline
RomRaider Donator

Joined: Mon Oct 21, 2013 6:35 am
Posts: 52
Location: Eastern ON, Canada
Is there a relationship between the Queries/sec that is displayed at the bottom of the Logger and the Time column in the Logger spreadsheet file?

E.g, is it possible to calculate the average queries/sec of a log from the spreadsheet Time column increments?


Top
 Profile  
 
 Post subject: Re: Logger "queries/sec" vs the spreadsheet "Time"
PostPosted: Sun Mar 12, 2023 4:11 pm 
Offline
RomRaider Developer

Joined: Wed May 20, 2009 9:49 pm
Posts: 7314
Location: Canada eh!
Sure. Count the number of lines logged in 1 second, this will give you queries/sec.


Top
 Profile  
 
 Post subject: Re: Logger "queries/sec" vs the spreadsheet "Time"
PostPosted: Sun Mar 12, 2023 8:38 pm 
Offline
RomRaider Donator

Joined: Mon Oct 21, 2013 6:35 am
Posts: 52
Location: Eastern ON, Canada
That's certainly simple enough; I had thought it was more complicated. But having now done the calculations for a number of logs, it all works out, including the relationship between the resultant queries/sec and the number of parameters (columns) being logged

Thanks !


Top
 Profile  
 
 Post subject: Re: Logger "queries/sec" vs the spreadsheet "Time"
PostPosted: Wed Mar 15, 2023 6:00 am 
Offline
Newbie

Joined: Wed Mar 15, 2023 5:49 am
Posts: 1
Yes, there is a relationship between the number of requests/s displayed at the bottom of the recorder and the "Time" column in the recorder spreadsheet file. The number of requests/sec in the logger shows the rate at which data is coming into the logger. This data is written to the spreadsheet file, where it is linked to the "Time" column. Thus, you can calculate the average number of requests/sec of the log from the increments of the time column of the spreadsheet using the formula: number of requests/sec = number of log entries / recording time.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Style based on FI Subsilver by phpBBservice.nl