Thank you for reading the post, I am creating a new test application with mysql database. application will have a simple registration process and will allow user to login as well.
Is it a good idea to have two seperate tables one for registration and one for login?
I am thinking of creating two tables, login & registration. application will write two insert statements one into login table and other to registration table. login table will handle only user try to login their queries and registration table wil handle only registration process.
Do you guys think is it a best practice. Also was thinking if all information written to registration can written to another table which can be used for viewing profile.
I dont know is it good practice to have too tables with similar type of data, only my reason of doing is not too to do too many queries to one table or??
I hope you understand....I will wait for your reply.
oh well i was thinking that alot of queries will not only going to one table which is the main reason i was thinking of one table. but if you have an application with 6000 users using it at the same time, won't it affect the database or make the database crash or anything like that