DMX_SearchResults has many records, but no index is on the table?

Bring2mind

Select the search type

Site
Web

Search

Support

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > Document Exchange > Search

DMX_SearchResults has many records, but no index is on the table?

Last Post 11/22/2010 12:14 PM by Peter Donker. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

SHC Forums

New Member

New Member
Posts:3

11/11/2010 6:27 PM
There are 8,082,834 rows in our current DMX_SearchResults table in our database instance, but there no index on this table and we are not sure how this table is even used or populated? Is this table used when a user executes a search each time somehow? Thx! Todd

Peter Donker

Veteran Member

Veteran Member
Posts:4536

11/16/2010 6:35 PM
Hi Todd, Indeed. There is a key in the table to identify the time and the session. The results for a particular user get removed once he/she searches again. After a while old search results get auto deleted. Note that this table does not contain any "content" but only pointers to documents that matched search criteria. On the auto deletion: the values in the key column start with a date code. This must not be older than today. Peter

SHC Forums

New Member

New Member
Posts:3

11/16/2010 8:19 PM
Thx for the response! We are running DMX 05.02.07. When I look at the table DMX_SearchResults, which currently has 8,508,483 entries, there are no indexes, triggers, primary keys, etc on it, plus the three columns I do see on it are SearchID, EntryID, and Rank. Is the SearchID the key you mentioned, and if so, what other tables does this one connect will to get the date info specified? It just seems to us that the amount of records is very high, and without indexes, etc, not sure if its performing as it should. Should we be clearning this table out from time to time ourselves? Any more info would be appreciated. Todd

Peter Donker

Veteran Member

Veteran Member
Posts:4536

11/22/2010 12:14 PM
Hi Todd, This issue was fixed in 5.2.8. Peter

You are not authorized to post a reply.

Forums > Document Exchange > Search

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.

© 2024 Bring2mind Terms Of Use Privacy Statement