 Search the Knowledgebase |
 Browse by Category |
|
|
|
|
|
| Searching is very slow to respond ...or... A recipe appears in the default list, but doesn't appear when searching by name. |
| User Opinions |
100%
0%
(4 votes)
|
|
Thank you for rating this answer.
|
In certain cases (sometimes after an update has been installed), the log file associated with the ESHA Database becomes damaged or corrupted, causing searching in the program to be unreliable. In this scenario:
- Close your ESHA software.
- On the server which hosts your database, launch Database Utility (found in the Windows Start menu, under ESHA). If your operating system is Windows Vista, Windows 7 or Windows 2008 Server, there is need to right-click the shortcut and choose Run As Administrator for Database Utility.
- Connect to the SQL Server & database.
- Backup the database.
- After backup, click Database / Shrink.
- Exit Database Utility.
After the above, launch your program try searching again.
Advanced: If using your own instance of SQL Server, or you have SQL Server Management Studio (Express) installed (a free download from Microsoft), you can force a rebuild of certain indexes which may help searching. Specifically:
- Using Management Studio (Express), connect to the proper SQL server instance, and open the ESHA Database.
- Expand Tables.
- Expand BaseFoodName table.
- Right-click the Indexes listing, and choose Rebuild All.
- Click OK to the Rebuild Indexes dialog.
- Exit Management Studio (Express).
|
| Attachments |
|
No attachments were found.
|
| Related Questions |
|
No related questions were found.
|
Print this page
Email this page
Post a comment
Subscribe me
Add to favorites