View Single Post
  #3  
Old February 8th, 2005, 09:17 PM
Michael Shaw
external usenet poster
 
Posts: n/a
Default Tables and memo fields

Hello!
I'm about to import a database which has four memo fields - author
biography, book review, table of contents and cover blurb.

Does having fields containing large amounts of text have a major impact
on search performance? Should I put the memo fields in a separate table?

Each record has 70 fields (not all populated) and there will be
approximately 600,000+ records.
Many thanks
Michael