Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Hyphen in Text Field really slows

Featured Replies

I have an indexed field: (Model Number) which houses data such as: "Freud 99-036" or "Freud 44665" and so on.

120k records in the database.

Whenever I search for an item with a hyphen in it, it severely hangs, like for 2-3 minutes before returning the results.

Is there a solution?

Have you tried reindexing the field? It is a text field correct? It shouldnt take that long.

How exactly do you "search for an item with a hyphen in it"?

  • Author

Perhaps I am using the wrong word. I have always assumed that a hyphen and a dash were the same thing. There's a lot I don't know though.

It is a text field (indexed, since it is our main field)

I go into find mode, select the model number field, and type the following text (without the double quotes): "Freud 99-036" and then click find.

I am not sure what you mean by "dash". Assuming you are using a hyphen (minus), it should work. Make sure that the field indexing is defined as "All" or "Automatically create indexes as needed". Re-indexing the field, as suggested by John, is certainly worth-while.

Another test you can perform: click in the field, select Insert > From Index… and check the 'Show individual words' option. See if 99-036 is listed as an individual word.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.