« DRAFT Watermark | Main | Copy directories and maintain permissions »
December 07, 2011
Optimizing Node Reference Autocomplete
Looks like the way to do this is to use a View (under advanced settings for the CCK field) that is optimized with filters and caching. Haven't tried this out though.
Something that may be more efficient in your case: Use a view to restrict the list of possible nodes instead of restricting by type. This will allow you to optimize your query by removing the ORDER BY and avoiding any sorts on the returned list.
And a suggestion from daggerhart via IRC:
additionally, you could write you own query, and use it in the view instead of the generated one (you'll have to hook into the view before it executes)
Posted by kkwaiser at December 7, 2011 03:55 PM
Trackback Pings
TrackBack URL for this entry:
http://mblog.lib.umich.edu/mt-bin/mt-tb.cgi/2318
Listed below are links to weblogs that reference Optimizing Node Reference Autocomplete:
» GS test demo from GS test demo
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 3, 2013 10:32 AM
» christian louboutin men shoes from christian louboutin men shoes
Il s'agit d'un impressionnant blog.Really merci! Grande. [Read More]
Tracked on April 6, 2013 04:22 AM
» http://www.ametco.com/biebershoes.php from http://www.ametco.com/biebershoes.php
A two met to shake hands while quips while you the specifications are high, and the old in our military ah! The secretary said there can not ah, we can not take your army ah! Your secretary is not just adjust it? Journalists should understand, Christia... [Read More]
Tracked on April 9, 2013 06:12 AM
» nike flyknit from nike flyknit
It occurred to me that plants can be something really mysterious and as alive as a jumping fish. Beeches with white arms embracing above our head, squat oaks and tortured elms straggled cheek by jowl of the beeches. Nettles choked the terrace, ivy held... [Read More]
Tracked on April 22, 2013 03:51 PM
» Wholesale Oakley Sunglasses from Wholesale Oakley Sunglasses
Hey there just wanted to give you a quick heads up. The words in your content seem to be running off the screen in Safari. I'm not sure if this is a format issue or something to do with web browser compatibility but I figured I'd post to let you know. ... [Read More]
Tracked on April 25, 2013 02:28 AM
» aumkbags.com from aumkbags.com
Terminate Air Jordan 11 Concord Restock Complaints Completely [Read More]
Tracked on April 25, 2013 05:51 PM
» dnEYKRYb from dnEYKRYb
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 25, 2013 06:05 PM
» burberry bags from burberry bags
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 26, 2013 06:53 AM
» celine bags from celine bags
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 26, 2013 08:08 AM
» seo tools from seo tools
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 26, 2013 02:00 PM
» miu miu from miu miu
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 28, 2013 08:40 PM
» toms outlet from toms outlet
The fashionable toms outlet are always nice chocies for summer days. [Read More]
Tracked on April 29, 2013 03:40 AM
» sac louis vuitton from sac louis vuitton
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 29, 2013 07:27 PM
» mulberry bags from mulberry bags
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on April 30, 2013 04:18 AM
» Mulberry väskor rea from Mulberry väskor rea
inside the first region. Definitely you truly can press by yourself about the IIII brink in 5 mins. I used to JJJJ be in the extremely pool of sweat.Women and men have to have wound up geared towards this mulberry british isles variety of handle that w... [Read More]
Tracked on May 2, 2013 08:25 PM
» Burberry Outlet Online from Burberry Outlet Online
Beauty is the staff of life,so come on to toms outlet for more choices. [Read More]
Tracked on May 2, 2013 10:11 PM
» Burberry Outlet Online from Burberry Outlet Online
The widely acclaimed toms outlet are hot on sale now. [Read More]
Tracked on May 3, 2013 10:05 PM
» hermes bags from hermes bags
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 4, 2013 05:26 PM
» seo software from seo software
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 6, 2013 12:54 AM
» nike lebron 10 from nike lebron 10
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 7, 2013 06:36 AM
» prada bags from prada bags
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 7, 2013 06:36 AM
» wholesale designer handbags from wholesale designer handbags
Data Discussions: Optimizing Node Reference Autocomplete discount designer handbags [Read More]
Tracked on May 16, 2013 02:53 AM
» Cheap NHL Jerseys from Cheap NHL Jerseys
When fans speak about the greatest players of all time in baseball, why do not they mention Al Kaline? Why isn't he mentioned with the likes of Mickey Mantle and Babe Ruth? [Read More]
Tracked on May 16, 2013 09:18 PM
» Oakley Flak Jacket Sunglasses from Oakley Flak Jacket Sunglasses
Handful of players could do what Kaline could on the field. He could hit for power, constantly had a high batting typical, and was a perennial gold glover in suitable field. He simply had no weaknesses. He won a batting title at the young age of 20! He... [Read More]
Tracked on May 19, 2013 01:43 PM
» Diablo 3 Gold from Diablo 3 Gold
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 21, 2013 12:55 PM
» cheap christian louboutin from cheap christian louboutin
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 21, 2013 07:55 PM
» parfume hermes from parfume hermes
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 28, 2013 01:18 AM
» AIR JORDAN?5 from AIR JORDAN?5
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on May 28, 2013 01:18 AM
» Cheap New Era Hats from Cheap New Era Hats
what wholesale snapback hats expense is there in copying and distributing laptop files? The reduce the price that publishers see nike no cost running shoes [Read More]
Tracked on May 29, 2013 10:08 AM
» Detroit Red Wings Jersey from Detroit Red Wings Jersey
the significantly less [Read More]
Tracked on May 29, 2013 10:18 PM
» Cheap Wow Gold from Cheap Wow Gold
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 5, 2013 01:52 PM
» wholesale apple ipad from wholesale apple ipad
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 5, 2013 01:52 PM
» vibram five fingers shoes from vibram five fingers shoes
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 7, 2013 06:47 AM
» nike tn from nike tn
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 7, 2013 06:47 AM
» cheap duncan keith black jersey from cheap duncan keith black jersey
Amazon has proficiently utilised low-cost nba snapback caps [Read More]
Tracked on June 9, 2013 04:52 AM
» cheap christian louboutin shoes from cheap christian louboutin shoes
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 11, 2013 11:51 PM
» Burberry Jacket from Burberry Jacket
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 12, 2013 08:39 AM
» MBT MENS SHOES from MBT MENS SHOES
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 12, 2013 08:39 AM
» Toms Shoes Outlet from Toms Shoes Outlet
On whether they kissed [Read More]
Tracked on June 17, 2013 10:52 PM
» toms sale from toms sale
What'd Team Dre do? Let Dre be Dre. After months of progress, Kevin Lee presented Dre using the first final unit, seen here for the very first time ever. [Read More]
Tracked on June 17, 2013 10:53 PM
» Lancel Sacs à main from Lancel Sacs à main
ces soldes sac lancel sur le marché des matières plastiques, brun chocolat, Une tasse de progrès depuis sacs de café, un roman ainsi que, torche Par exemple, si mon organisme est pris alors que pendant le train avec des pressions, réduit fondation... [Read More]
Tracked on June 17, 2013 11:09 PM
» AABX from AABX
Data Discussions: Optimizing Node Reference Autocomplete [Read More]
Tracked on June 18, 2013 07:21 AM