Is there any difference in performance between these two commands ($ and ATC())? I currently have a rather large database (12,800 records and growing) with about 4 fields, one of which is a memo field. Each record probably has about 600-1000 characters of text in it's memo field. I have to search these memo fields for certain blocks of text. I'm using a SQL SELECT statement to retrieve the data and am using the $ to know whether or not the text they are looking for is in the memo field.
This works fine but the customer thinks it's too slow. If I change to an ATC() instead of a $ would this speed it up? Or is there something else that might improve performance?
Thanks,
-Don