Tony Roberts
wading in the water
Posts:21
 |
| 08-11-2009 09:19 AM |
|
I would like to purchase this module but installed the trial to test it out first. After installing the module I click on the Setup Initial Settings link and it just sits there and eventually times out. Same thing happens with the Control Panel and Setup Template links. Any idea why this might be happening?
We do have a LOT of users loaded into the system. Could this be causing a problem?
Thanks,
Tony |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-11-2009 09:47 AM |
|
What version of DNN are you running? Do you see any errors / messages under Admin / Event Viewer? -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-11-2009 09:49 AM |
|
I'm running version 4.09.04 of DNN. I have a module that doesn't support version 5 yet. The only errors I get in the Log Viewer are a Thread Abort Exception. |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-11-2009 10:01 AM |
|
I just ran a trace on the database to see what happened when I push the Initial Settings link. It looks like it's going through every user in the system individually. I'm not sure what it's trying to accomplish, but I imagine this is the reason it is timing out. We have a LOT LOT LOT of users in the system. We are still not in production, so I'm thinking if I delete all the users and then install the module, perhaps it will work. The question is, when I reimport all the users, will I run into this problem again? I'm not sure what the module is doing when it iterates through all the users. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-11-2009 10:36 AM |
|
Out of curiousity, how many users are there? A couple thousand or more? -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-11-2009 10:41 AM |
|
Way more. Around 200,000. You see why I want a better search module.  |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-11-2009 10:51 AM |
|
Okay, try this out. Instead of clicking on the "Setup Initial Links", click on the little down arrow and choose Control Panel instead. Here you can configure the search and templates to your liking. -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-11-2009 10:57 AM |
|
I've tried that and it does the same thing. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-11-2009 01:02 PM |
|
HI Tony, DUD has never been performed on a DNN site with 200,000 users plus. I talked to our chief developer Chad and we will need to research / modify the source code so that it won't read the entire users list on page load. Will keep you posted for a patch / version update to fix this issue. -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-11-2009 01:20 PM |
|
I figured I was a special case. For now, I'm going to delete all the users, install your module, then reimport all the users. Do you think that will cause any problems? |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-11-2009 01:39 PM |
|
Maybe. However, make sure after you delete the users and install the DUD module, also set up your templates / search fields first. Then perhaps try importing some limited number of users first instead of all 200,000 at the same time. -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 06:28 AM |
|
Ok. I removed all the users and was able to get the DUD module working. i was able to setup the templates and search criteria and was getting search results. However, I added the users back into the system and now searching returns "No search results". i set debug mode and used the criteria string in the where clause against the Users table and was able to get results quickly. Are you joining against any other tables that might cause the results to be filtered out? Is there anything else I should be trying?
Thanks for the help. |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 06:43 AM |
|
Update. I figured out that your search limit field is actually limiting the amount of users you search on, not the number of results. That seems reallly strange. Now my problem is when I increase that number, it takes forever to return search results. Are you looping through all of the users or something? |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-12-2009 06:46 AM |
|
Hi, can you list your search fields and conditions here? -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 07:07 AM |
|
Sure. It's pretty simple. I'm just searching on username and first/last name.
[Username] LIKE 'test%' and [FirstName] like '%' and [LastName] like '%' |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-12-2009 07:16 AM |
|
In Control panel / Search Fields, you should set up three search criterias:
1) fieldname: Username; criteria: contains
2) fieldname: Firstname; criteria: contains
3) fieldname: Lastname; criteria: contains
For each of the search fields, also set:
input type: textbox
condition: AND
Searchable: check
Contains takes care of the % issue. If you want something like TEST%, then you should also check the "Begins With" criteria as well. Play around with these settings and see if it works for you. -- David
|
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 07:23 AM |
|
I have them all setup as "Begins With" and all are marked searchable. But if I increase the search limit, it takes forever and comes back with no results. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-12-2009 07:26 AM |
|
You don't need to use Begins With for Firstname and Lastname because then you can just use "CONTAINS" instead and not type in anything which would be the equivalent of %. Right now, you have Firstname and Lastname set to "Begins with" and then you type in '%', which means it's looking for a name that begins with a literal '%' which doesn't exist and therefore isn't returning anything. You need to change it to "CONTAINS" and then don't type in anything which would be the equivalent of '%' for everything. -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 07:35 AM |
|
I'm not typeing in anything for the first and last name. The query string I listed above is using a LIKE for both names as it should. The problem seems to be that the amount of records that are being searched is limited by that search limit value. And if I increase that value, the search becomes unusable. |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 07:40 AM |
|
I forgot to mention that if I choose the right search values, it does come back with some results, but it's only searching on the first 300 records in the database. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-12-2009 07:42 AM |
|
Under Module Configuration / Search, what do you have set for:
Maximum number of results rendered before Search / Filter (0 for no limit)?
-- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 08:17 AM |
|
I started with 300. When I did that, I had to search for users within the first 300 in the system and it would find some. I just tried changing it to 0, but it never brings back any results. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-12-2009 08:36 AM |
|
How many users do you have in the system now? Also, if you set it to 0 now, can you narrow down the search and perhaps type in something for firstname or lastname and see if it returns anything instead of leaving them blank? -- David |
|
|
|
|
Tony Roberts
wading in the water
Posts:21
|
| 08-12-2009 08:40 AM |
|
I've got the full 200,000 in the system. I've set it to 0 and searched for a single user that I know is in the system. Nothing ever comes back. It looks like it's timing out. |
|
|
|
|