Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161

    Unanswered: To split the table or not ?

    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
    MySQL 5.1

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    not really
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161
    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 ?
    MySQL 5.1

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the TEXT fields aren't stored on the same row anyway, so no
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2004
    Posts
    62
    It based on you db design

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •