AnsweredAssumed Answered

Import and search full text files?

Question asked by edyas on Jun 8, 2018
Latest reply on Jun 13, 2018 by edyas

Hi Everyone,

 

I need your advice on my next move, before I do anything silly ;-)

I have a database of about 10,000 records (main table).

I am considering the import of "large" (about 20 A4 pages) chunks of text within each record.

 

My only purpose is to enable full text search or, more specifically, to combine full text search with search queries in the other "analytical" fields (date, name, etc.).

 

Is that the best way to proceed, namely to import full text into the database?

Or will Filemaker be very slow with full text search?

If import is a good idea, is there any "best practice" as to how the text should be stored (eg type of file, dedicated table)?

 

 

Many thanks for your help!

Outcomes