{"id":3392,"date":"2012-02-16T13:50:06","date_gmt":"2012-02-16T05:50:06","guid":{"rendered":"http:\/\/www.sharepointboost.com\/blog\/?p=3392"},"modified":"2023-07-31T11:40:00","modified_gmt":"2023-07-31T03:40:00","slug":"performance-comparison-cascaded-lookup-3-0-vs-cascaded-lookup-2-x","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/performance-comparison-cascaded-lookup-3-0-vs-cascaded-lookup-2-x\/","title":{"rendered":"Performance Comparison: Cascaded Lookup 3.0 Vs Cascaded Lookup 2.x"},"content":{"rendered":"

Hardware Environment<\/h2>\n

This performance test is tested in the following hardware environment:<\/p>\n

Server:<\/p>\n\n\n\n\n\n
Component<\/td>\nConfiguration<\/td>\n<\/tr>\n
Processor<\/td>\n64bit, four cores, 2.66GHz<\/td>\n<\/tr>\n
RAM<\/td>\n8GM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Client:<\/p>\n\n\n\n\n\n
Component<\/td>\nConfiguration<\/td>\n<\/tr>\n
Processor<\/td>\n64bit, four cores, 2.33GHz<\/td>\n<\/tr>\n
RAM<\/td>\n8GM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Lookup Performance:<\/h2>\n

Lookup performance refers to the load time of the New\/Edit item page of the list which contains Cascaded Lookup column or Cross-Site Lookup column.<\/p>\n

New\/Edit item Page Load time: the time interval from the request to all content of the list item displayed.<\/p>\n

The main factor to affect the page load is:<\/p>\n

    \n
  1. The number of Cascaded Lookup columns or Cross-Site Lookup columns in the list.<\/li>\n
  2. The number of items in the source list of each Cascaded Lookup column or Cross-Site Lookup column.<\/li>\n<\/ol>\n

    The following are the detail record charts for the average page load time when the New\/Edit item page contains Cascaded Lookup column or Cross-Site Lookup column:<\/p>\n

    1. SharePoint 2010 version<\/div>\n

    Browser: IE8<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    “Cascaded Lookup 3.0” Vs “Cascaded Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cascaded Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n2.33<\/td>\n1.00<\/td>\n57%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n4.00<\/td>\n1.00<\/td>\n75%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n4.00<\/td>\n2.33<\/td>\n42%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n5.67<\/td>\n2.67<\/td>\n53%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n14.00<\/td>\n4.33<\/td>\n69%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n22.00<\/td>\n5.00<\/td>\n77%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n58.33<\/td>\n14.67<\/td>\n75%<\/td>\n<\/tr>\n<\/tbody>\n
    “Cross-Site Lookup 3.0” Vs “Cross-Site Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cross-Site Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n2.00<\/td>\n1.75<\/td>\n13%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n2.33<\/td>\n2.00<\/td>\n14%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n3.67<\/td>\n2.00<\/td>\n45%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n7.67<\/td>\n3.00<\/td>\n61%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n13.33<\/td>\n3.50<\/td>\n74%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n24.00<\/td>\n7.25<\/td>\n70%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n56.67<\/td>\n16.33<\/td>\n71%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Browser Firefox 10:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    “Cascaded Lookup 3.0” Vs “Cascaded Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cascaded Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n4.00<\/td>\n1.67<\/td>\n58%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n5.00<\/td>\n2.00<\/td>\n60%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n5.33<\/td>\n2.33<\/td>\n56%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n8.33<\/td>\n3.00<\/td>\n64%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n13.00<\/td>\n5.67<\/td>\n56%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n24.33<\/td>\n9.00<\/td>\n63%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n39.33<\/td>\n17.33<\/td>\n56%<\/td>\n<\/tr>\n
    “Cross-Site Lookup 3.0” Vs “Cross-Site Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cross-Site Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n4.33<\/td>\n3.00<\/td>\n31%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n4.67<\/td>\n3.33<\/td>\n29%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n5.33<\/td>\n4.00<\/td>\n25%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n7.00<\/td>\n5.00<\/td>\n29%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n13.00<\/td>\n5.33<\/td>\n59%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n20.33<\/td>\n8.67<\/td>\n57%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n38.00<\/td>\n15.33<\/td>\n60%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    2. SharePoint 2007 version<\/div>\n

    Browser: IE8<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    “Cascaded Lookup 3.0” Vs “Cascaded Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cascaded Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n0.73<\/td>\n0.60<\/td>\n18%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n1.00<\/td>\n0.90<\/td>\n10%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n2.00<\/td>\n1.00<\/td>\n50%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n4.00<\/td>\n2.00<\/td>\n50%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n10.67<\/td>\n5.33<\/td>\n50%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n129.00<\/td>\n9.33<\/td>\n93%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n413.00<\/td>\n16.67<\/td>\n96%<\/td>\n<\/tr>\n
    “Cross-Site Lookup 3.0” Vs “Cross-Site Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cross-Site Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n0.80<\/td>\n0.57<\/td>\n29%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n1.00<\/td>\n1.00<\/td>\n0%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n3.00<\/td>\n1.00<\/td>\n67%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n5.00<\/td>\n2.67<\/td>\n47%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n11.00<\/td>\n5.00<\/td>\n55%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n146.00<\/td>\n8.00<\/td>\n95%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n520.00<\/td>\n19.67<\/td>\n96%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Browser Firefox 10:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    “Cascaded Lookup 3.0” Vs “Cascaded Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cascaded Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n1.67<\/td>\n1.67<\/td>\n0%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n2.00<\/td>\n2.00<\/td>\n0%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n4.00<\/td>\n2.33<\/td>\n42%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n6.33<\/td>\n3.00<\/td>\n53%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n15.67<\/td>\n5.67<\/td>\n64%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n23.67<\/td>\n9.00<\/td>\n62%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n54.67<\/td>\n17.33<\/td>\n68%<\/td>\n<\/tr>\n
    “Cross-Site Lookup 3.0” Vs “Cross-Site Lookup 2.x” Performance Comparison<\/td>\n<\/tr>\n
    Item(s) * Cross-Site Lookup Column(s)<\/td>\nTotal Items<\/td>\nElapsed Time (sec) Former Version 2.x<\/td>\nElapsed Time (sec) New Version 3.0<\/td>\nPerformance Improvement<\/td>\n<\/tr>\n
    2000*1<\/td>\n2000<\/td>\n1.33<\/td>\n1.00<\/td>\n25%<\/td>\n<\/tr>\n
    2000*2<\/td>\n4000<\/td>\n2.00<\/td>\n2.00<\/td>\n0%<\/td>\n<\/tr>\n
    2000*4<\/td>\n8000<\/td>\n4.00<\/td>\n2.00<\/td>\n50%<\/td>\n<\/tr>\n
    10000*2<\/td>\n20000<\/td>\n9.00<\/td>\n3.67<\/td>\n59%<\/td>\n<\/tr>\n
    10000*4<\/td>\n40000<\/td>\n17.33<\/td>\n6.00<\/td>\n65%<\/td>\n<\/tr>\n
    10000*8<\/td>\n80000<\/td>\n30.00<\/td>\n9.33<\/td>\n69%<\/td>\n<\/tr>\n
    20000*8<\/td>\n160000<\/td>\n65.33<\/td>\n19.67<\/td>\n70%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

    Hardware Environment This performance test is tested in the following hardware environment:<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[347],"tags":[309,310,311,486,27],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3392"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=3392"}],"version-history":[{"count":19,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3392\/revisions"}],"predecessor-version":[{"id":5357,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3392\/revisions\/5357"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=3392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=3392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=3392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}