I know very little about programming. But I'm just wondering, could someone just enter the name of the episode in a new field in the same way you enter information in the Extra Info field so that the site wouldn't have to search for anything, it would just display the letters typed in the field. Would all this be too complex or take up too much space?

We need to draw this discussion to a close, do you think the whole thing is a bad idea and we should forget about it?

- take too much space in the database
- take too much time for entering
why do you want to type the title each time you add a vehicle rather than having to type the title once, and have the site find it when you type the episode number?

I didn't say that the whole thing was a bad idea, I just said that if I add it, it would be a more automated solution. Of course it would be a little more work to add it to the site than just adding a new field, but it would work better too.

Why should the site have to be programmed to automatically sort it out? The thing is each different episode title would have to be typed in at least once, and there won't be that many different vehicles per episode, you could just copy the title once you've typed it and paste it into the field in the admin section for each vehicle on that episode, it wouldn't take that long at all. And it's not like I'm excepting you to sort it out for every TV series, you don't have to do any of them, other admins will be free to do it if they want to (I'll do the ones for my favourite TV shows), just think of it as a work-in-progress.

If a computer can do something in one millisecond and save space of the database, why do you want to do it yourself manually and waste database space?

Now I understand, it would take up space to enter everything manually. But would it take up that much space? Every time you enter a new car, you have to type in model names.

It would take more space if the title was stored each time in the vehicle page instead of having it once in a separate table.
There is often more than one vehicle in a episode.
It is not only for the space taken, but also to keep the database structure somewhat clean and coherent (it is already not perfect currently).

Yes, makes take space. And I could have a make list separated to not have to reenter it each time. Same for models actually. This is one of the improvements that I may do one day.

For info:

cars table = 7.9 MB
comments table = 34.4 MB
movies table = 1.5 MB
users table = 0.3 MB

total = 44.1 MB
max allowed = 50 MB

If the database reaches the max allowed size, OVH (where the site is hosted) will put it on another server, which is slower.
I could split the database and put comments & users in a separate database, but some day we will reach that limit.

I finally understand. Maybe episode titles might be a possibility one day, but for now there's too many things to sort out already.