If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Truncation of memo fields in SELECT queries - Access 2002 | datawizzard | Running & Setting Up Queries | 1 | January 26th, 2005 11:46 PM |
change field properties, reflect in query | SueP | New Users | 3 | November 11th, 2004 12:46 PM |
Memo fields and ODBC tables | blogan | General Discussion | 0 | July 15th, 2004 07:03 PM |
Access 2000, 2002 and BTRIEVE 6.14 problems with memo fields | SSGTech Tim | General Discussion | 0 | July 1st, 2004 05:42 AM |