The value of the total mileage in the database

Pavel2 years ago

Hello.

  1. Where can I find the total mileage value in the database tables?

https://imageup.ru/img163/4171952/no.png.html

  1. How is the total mileage value formed? (Each time the distance between points is summed or the result is stored in a database table)
Anton Tananaev2 years ago
  1. It's in the position attributes.
  2. When a new location is received, we take last known value and add a distance from the last known location.
Pavel2 years ago

But if I change totalDistance to a different value with deleting all the following lines here

https://imageup.ru/img116/4171968/bd.png.html

then here

https://imageup.ru/img163/4171952/no.png.html

everything remains the same.

I want to change the values to try to change the value so that there are no gaps in the summary, since the results are incorrect when forming, this is due to an unknown error (zeroing the total mileage), which I wrote about recently, and it could not be solved, so I want to do it manually.

IamJim25 days ago

I am sorry to ask and re-open this thread, but my question is also based on something similar, and I have spent time searching different keywords also now, so just need to ask and move on, as the forum is not in any separate category order

How much data space is required for each location retrieval please?

Mainly for now, if I were to record just once per hour using the Traccar Client app, and keep data stored for example 1 year?

How much disk space would I be burning per device please?

As getting ready to order a server and need to make sure I have enough 'horsepower' and storage also

Thank you in advance, Jim

Anton Tananaev25 days ago

Your question seems to be completely unrelated to the topic. How is disk space requirements related to mileage issues?

IamJim25 days ago

Agreed, and sorry...tired of trying to look thru a single forum - generic sorts & search

I am sorry to ask and re-open this thread, but my question is also based on something similar, and I have spent time searching different keywords also now, so just need to ask and move on, as the forum is not in any separate category order

How much data space is required for each location retrieval please?

Mainly for now, if I were to record just once per hour using the Traccar Client app, and keep data stored for example 1 year?

How much disk space is required please? To keep 1 year of truck data if that truck reports and logs every hour 24 hours a day 7 days a week 365 days a year

As getting ready to order a server and need to make sure I have enough 'horsepower' and storage also

Thank you in advance, Jim

Anton Tananaev25 days ago

It should be pretty easy to measure. I don't know exact numbers.

IamJim25 days ago

I suppose it would with SSH but I see>

https://www.traccar.org/forums/topic/dedicated-server/

Anton Tananaev25 days ago

Not sure how that thread is related to anything we're discussing here.

IamJim25 days ago

If one does not have access direct to database & storage used per recorded event to view or calculate from?

You must have a Plan B then as you say> It should be pretty easy to measure.

Do I use a ruler? A tape measure? -lol-

How about how much server is needed to real time track 10,000 -items- once per hour and keep that data stored for a 1 year period?

Anton Tananaev25 days ago

You get a small server and run a device for a day or so. Then check database size increment and multiply it to get your expected storage size.