|
-
September 14th, 2009, 06:55 AM
#1
Hypothetically
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.
-
September 17th, 2009, 03:06 PM
#2
Re: Hypothetically
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|