socialite
September 14th, 2009, 06:55 AM
If i were required to store about 150 vehicles in a database that kept track of everyday of the week for a week in advance at what times those vehicules were busy down to the minute would it be ok to create a box for every minute of the day and fill them in based on a form i created in php. This would be about 2400 boxes for every vehicule. which is 360000 boxes. Bear i mind ive had no training to handle large scale databases and its a personal hypothesis.
sotoasty
September 17th, 2009, 03:06 PM
I am not sure I understand what you are doing or want to display. But even saying that, I do not in any way think that 2400 boxes for someone to look at or fill in is ok.
You basically need to show the vehicle. Then a start and end time (calenday/time control) for it. (this for adding new times). For reviewing times, show the Vehicle, then a list of all the schedule times (start and end).
Maybe instead of the time control, you could use a popup menu. But you still don't want to display 2400 times for it. Start with AM/PM, then when selecting AM show 1-12 Same for PM. When an hour is selected, show 1st/2nd/3rd/4th quarter of hour, then when that is selected show the minutes. That way you can select any minute and not have too much info displayed at any one time.