To split the table or not ?

anjanesh · #1 (**permalink**) 08-13-06, 07:35

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 ?

Thanks

r937 · #2 (**permalink**) 08-13-06, 07:50

not really

anjanesh · #3 (**permalink**) 08-13-06, 08:13

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 ?

r937 · #4 (**permalink**) 08-13-06, 08:19

the TEXT fields aren't stored on the same row anyway, so no

pakcik_kantin · #5 (**permalink**) 09-13-06, 05:20

It based on you db design

Internet Services

Web Development

Digital Marketing

Consumer Tech