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!