SPCascadeDropdowns slow performance in Internet Explorer

Nov 12, 2010 at 4:09 AM


I am just starting to work with the SPServices library and I think it is terrific, but I am having a little trouble with a browser related issue in the Cascade dropdown function.

I am using jQuery 1.4.3 and SPservices 0.5.7.  I am also using just one cascade relationship and the relationship list has 30 items, but will have 471.  The code is running from the NewForm.aspx file and is running from a CEWP. 

The code runs very nicely within Firefox, but within IE (version 8 and version 9) it requires two clicks on the selected item. It also takes a couple of seconds to process in IE. 

I have included my code below.  Is this typical behavior using IE, or is there something I can do to improve this.  As I said, it works perfectly in Firefox.  As you can see, I have included the SPDisplay related in the same CEWP, but this seems to work fine.


I noticed that a similar question was asked previously, but it seemed to be resolved by removing some extra code, and I don’t believe I have any of that here.

Thank you for any advice.

 

<script language="javascript" type="text/javascript" src="../../ResourcesjQuery/jQueryMin.js">
</script>

<script language="javascript" type="text/javascript" src="../../ResourcesjQuery/jquery.SPServices-0.5.7.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function() { $().SPServices.SPCascadeDropdowns({
   relationshipList: "{GUID}",
   relationshipListParentColumn: "Title",
   relationshipListChildColumn: "TA",
   parentColumn: "Drug Name",
   childColumn: "Therapeutic Area",
   debug: true
  });

            $().SPServices.SPDisplayRelatedInfo({
                columnName: "Drug Name",
                relatedList: "{GUID}", 
                relatedListColumn: "Title",
                relatedColumns:["DrugAbbreviation","InternationalBirthDate","division"],
                displayFormat: "table",
                headerCSSClass: "ms-vh2",
                rowCSSClass: "ms-vb",
                debug: true
                });


 });


</script>

Coordinator
Nov 13, 2010 at 4:11 AM

pjenrow:

This actually has nothing to do with SPServices. Take a look at my blog post on this:
http://sympmarc.com/2010/05/19/two-types-of-sharepoint-forms-dropdowns/

M.

Nov 13, 2010 at 5:05 AM
Edited Nov 13, 2010 at 5:05 AM

Thank you very much for both writing the blog post and for pointing me to it!

Coordinator
Nov 13, 2010 at 5:43 AM

You bet!

M.

Nov 13, 2013 at 2:38 PM
Edited Nov 13, 2013 at 2:46 PM
Hi Marc,
Everything is work perfect for me except the slowdown issue . I'm using jquery-1.8.1.min.js and jquery.SPServices-0.7.2.min.js
I think I have the same problem as pjenrow. Here is my script:

<SCRIPT type=text/javascript src="../jquery-1.8.1.min.js"></SCRIPT>
<SCRIPT type=text/javascript src="../jquery.SPServices-0.7.2.min.js"></SCRIPT>
<SCRIPT type=text/javascript>

$(document).ready(function(){
    $().SPServices.SPComplexToSimpleDropdown({
        columnName: "School",
        completefunc: null,
            debug: true
        });


    $().SPServices.SPComplexToSimpleDropdown({
        columnName: "InstructorLastName",
        completefunc: null,
            debug: true
        });

    $().SPServices.SPCascadeDropdowns({
    relationshipList:"Instructors",
    relationshipListParentColumn:"School",
    relationshipListChildColumn:"Title",
    parentColumn:"School",
    childColumn:"InstructorLastName",
    CAMLQuery:"<Eq><FieldRef Name='Display'/><Value Type='Boolean'>1</Value></Eq>",
    simpleChild: true,
    debug: true
    }); 


    $().SPServices.SPComplexToSimpleDropdown({
        columnName: "InstructorFirstName",
        completefunc: null,
            debug: true
        });

    $().SPServices.SPCascadeDropdowns({
    relationshipList:"Instructors",
    relationshipListParentColumn:"School",
    relationshipListChildColumn:"First_x0020_Name",
    parentColumn:"School",
    childColumn:"InstructorFirstName",
    CAMLQuery:"<Eq><FieldRef Name='Display'/><Value Type='Boolean'>1</Value></Eq>",
    simpleChild: true,
    debug: true
    }); 


    $().SPServices.SPCascadeDropdowns({
    relationshipList:"Instructors",
    relationshipListParentColumn:"Title",
    relationshipListChildColumn:"First_x0020_Name",
    parentColumn:"InstructorLastName",
    childColumn:"InstructorFirstName",
    simpleChild: true,
    debug: true
    }); 

});

</SCRIPT>

My first list is "Schools" with one column: title (about 22 items)
second list is "Instructors" with 4 column: School(lookup column to School list), Title(Instructor Last Name), First Name, Display(yes/no: indicate to display in the dropdown (about 9000 items)
third list is "Schedules" with : School(loopup column to School List), InstructorLastName(lookup column to Title in Instructors list), InstructorFirstName(lookup column to FirstName in Intructors list) .
Am I doing something wrong or missing something? it take me over 20 seconds to load it.
Any help would be really appreciate.
Thanks so much.

TP.