If what you are saying is right “means that it wont increase server load” …
Well, logically, the server will have more work to do — but it should be entirely manageable if things are set up well. The way you build your queries and indexes will be important.
This sort of application is also a prime candidate for using stored procedures, if you’re interested in learning about them. It could benefit efficiency, accuracy, and security.
Most importantly, test, test, test …!
Switching between backends will be the most difficult part, so make sure to develop the new version independently, and make sure you can switch back quickly if need be.
Any other questions, let me know.
i made the db through GUI of PHPmyAdmin never noticed that …
Well, at the end of the day, it’s no big deal — MySQL will simply convert that
0 on insert. Under default settings, it won’t even issue a warning. It’s still good to be aware of such things, though.
it began with only two possible keys and went onto become 6-7 …
Which is how things typically develop. : )