Hi.

I want to make a database which'll have many tables. One of the table is USER. So I want to search username in User table. My question is if there are 3 fields in this table will it take less time to get search result of username as compared to if I've 30 fields in this table. Or you can say if there are less number of fields in a table then will it take less time to search any field from thousands of records. If this is so then is it a good idea to shif some of the fields of User table in any other table?:confused:

If UserName is a specific field, it won't matter how many other fields there are, they're not being searched. The search will operate as quickly as ever if you restrict the search to the single field UserName.

A lot depends on how you do your searches and how your database is designed.

Generally fields that will be searched are indexed. Indexed fields will search faster that non indexed fields, regardless of the number of fields in the table.

But keeping the number of fields down is a principle of relational database design. I suggest you read up on normalization.

Quote:

---

Originally Posted by ScottGem

A lot depends on how you do your searches and how your database is designed.

Generally fields that will be searched are indexed. Indexed fields will search faster that non indexed fields, regardless of the number of fields in the table.

But keeping the number of fields down is a principle of relational database design. I suggest you read up on normalization.

---

But my question is that if there are 3 tables in a database and I've to search from the 1st table then if either size of the 1st table is big or small, will it change speed of search if the 1st table is small as compared to being big.

We answered that, The number of fields doesn't affect searches unless you are trying to do a full text search throughout the table. Otherwise searching is restricited to the field being requested in the search,