View latest data
.com - London Transport Service Vehicles on the web
You are not logged in.
Log-in Register
News
Fleet Data
Locations
Pictures
Articles
Forum
An all-new version of this website is now available at www.ltsv.com/sv/. These pages are no longer being updated.

Forum Post
Forum: Web Site
Topic: Diary of a Webmaster

Post
Created
By
Replies
What is Database Admin?
Sat 17/06/06, 23:06
0 Replies
Some of you may have seen this as being the last change to edited vehicles. The explaination is related to my ''brilliant'' scheme of spacing the ID numbers allocated to SV records so that subsequent additions could be fitted in while retaining the registration order. This has almost completely failed! It seems that every newly reported vehicle falls where this is no gap in the IDs. I then need to shuffle several vehicles on either side, taking care to include any picture, sighting or allocation records with them. All very tedious!

There is a way around this. Just give every SV a sequential ID as it is added. I am currently working on how best to sort records with this in place. The other benefit is that it would allow many more records to be added. Hires and Streets vehicles have been mentioned before. Other companies such as Almex could also go in, perhaps even the Dial-a-Ride minibuses!
Note: Posting edited by Thomas Young, 17/06/06, 23:07.


Showing Replies 1 to 0 of 0
Log-in to add your own reply.
Replies (Most recent at top)
Created
By