We have developed a form that has a combo box of as the very first field. It provides a dsiplayed LastName,FirstName to the users but stores the selected person’s ID in the field instead(i.e. QuestionValue/QuestionValueOption). We then later use the saved ID to perform a select back against the database (via a Question Event) to re-capture the lastname/firstname to make the student name available for Emails and PDFs as part of the Completion Event process (and to store the name in the database as additional info).
 
Here’s the issue. This all works great on a local development machine. The combo lookup for the name occurs in less than two seconds and both name and ID fields display in emails and forms as well as rolling out to our SQL database (via our SQL completion event).
 
When I export/import this form and move it to the production server…the combo list shows up (there are only about 80 people in the list)….but when a name is selected, processing that combo choice (via the progress bar at the bottom of the Internet Explorer page) takes around 15 seconds. If we attempt to enter the subsequent field during that time (a text field) it gets “blanked out” upon completion of the progress bar associated with the combo box. Another negative effect is that the Question Event that runs a SQL to re-select the lastname/firstname to another field via the ID no longer works (it shows up as blank). This process has worked fine on the development box.

We also have a combo date field (month, day, year) on the form. After the month is selected, it takes 15 seconds for the list of possible days for that month to come up (on our production server) Again, on our local development machine, the list of days is populated immediately.

We are wondering what might be able to do to speed up the performance of Dynamic Forms on our server …if there are any special tools available to understand why we see a ten-fold time increase between our development box and our production server.

One additional piece of information.  On the production side..when running in debug mode, I can see a reference to processing the Question event:

**** Preparing to process all Affected Field Question Events **** Processing Affected Questions ield value for question event:Intern For SQL Question Event:InternNameFromSQL1

And I then see a well formed query that successfully that runs in DNN's HOST/SQL (when I take it there and test it)

but then I see just below in the debug info I get this:

Invalid object name 'TeacherEd.dbo.TED_TCHR_CRSE'.


Yet, I don't seem to experience this problem in my local DNN environment.

To summarize:

                 All three SQL related events:
                1) Initial combo box lookup
                2) SQL re-select via Question Event
                3) SQL Completion Event
                                           work correctly in my local environment

On our production server items 1 and 3 work (though 3 is missing the name info) because item 2 did not work...due to the error above.

Another observation.

On my local development environment, the DNN database resides on the same server as the database I am trying to get to perform the Question Event SQL query.  It works there...and since there is no option to spell out an external connection string...I assume it is using the default DNN connection string?    The databases are on the same SQL server so no problem

Whereas, in our production environment..the DNN database is on a different SQL server from the database I am trying to reach.  As a result, since it is not using any external connection but relying on the default DNN, it can't find this other database needed for the Question Event SQL query (generating the Object not found error).

If this is the case, just trying to figure out the workaround for this.