I don't know how to express my thanks to your helpful answer and Brent Fraser,
as well.
specially, i wasn't careful about using views in this application.
>>You don't need a table per vehicle, as all share the same columns, you just
>>need to have a vehicle id >>column to be able to select
I've done similar to Brent's suggestions, but tracking boats with 2 hourly
updates. We just stored all the location data in one table with a reference id
to a boat name and details in another project.
The default setting showed the current location and the last 72 hours of
track... Using a quer