I got a form to make which has many fields. The first half are basic info like Name, Address, City etc etc which are varchar or int etc.
The latter half consists of questions for which the answers are of TEXT datatype. I currently have this in one single table.
Would it make any difference if I have the Answers part in a separate table ? Would it do any good in terms of performance ?
On my website, I have a search form - basic and advanced. Basic doesnt search the Answers (TEXT) fields while Advanced does. So for the basic search, wouldnt it the query be faster if it searches only the 1st table, rather than a table containing some 20 TEXT fields too which are searched only in the Advanced Search ?