Thread: db manage for improve speed.
06-25-15, 22:16 #1Registered User
- Join Date
- Jun 2015
Unanswered: db manage for improve speed.
hi friends, i am starting to create my first web application in my career.
i am using mysql server.
i am going to make table which contain users information (like id, firstname, lastname, email, password, phone number).
which is batter way to speed up my database from below ?
method 1: put all data into one single table(userinfo).
method2: divide all data by alphabet character and put data into many tables. for example, if user's email id is Joe@gmail.com that put into table(userinfo_j) and if user's email id is firstname.lastname@example.org that put into table(userinfo_k).
please suggest me which is better method ?
06-26-15, 02:38 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
What makes you think you would have a 'speed' issue if you stote all the users in one table.?
Properly designed using appropriate indexes there should be virtually no difference in retrival times, marginally more tine consumed on insert with a single table. Unless you have evidence there is a performance issue then store in one tableI'd rather be riding on the Tiger 800 or the Norton