I can see the point about multiple content databases, but they could have at least allowed a query against another site collection (one at a time). This would save many people having to resort to 3rd party tools or custom development.
From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Jeremy Thake Sent: Thursday, 28 January 2010 6:59 PM To: paul.culm...@sevensigma.com.au; ozMOSS Subject: RE: CQWP in 2010 With the new Developer Dashboard, if you did put a web part on a page that did a cross site collection query...you'd be able to see the timings on the page based on what object model calls were happening. Would be interesting, but Paul is correct...hopping between two site collections means two databases which results in taking the data up into the application server memory and joining the data there. Maybe that's what the 64-bit minimum requirement and min 6GB RAM is for ;-) From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Thursday, 28 January 2010 1:40 PM To: 'ozMOSS' Subject: RE: CQWP in 2010 Thats an architectural limitation of content databases. When you think about it, crossing site collections is actually quite inefficient because its two separate underlying SQL databases. I'd be very interested indeed just to see how expensive SDK based cross site collection queries are at a DB level. Ie slap on the lightning conductor web part, pull some data and to a sql trace. Perhaps the numbers have been crunched somewhere - I've not gone looking. Regards Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Jason Taylor Sent: Thursday, 28 January 2010 1:36 PM To: ozMOSS Subject: RE: CQWP in 2010 Looking at the query scope settings they look exactly the same as 2007, allowing only site collection, sites & sub-sites or a list. Unless there is something under the hood it doesn't look like you can. Cheers, Jason Taylor SAGE Automation From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 28 January 2010 10:40 AM To: ozMOSS Subject: CQWP in 2010 Can anyone confirm whether the Content Query Web Part in 2010 has been enhanced to allow cross-site querying? Regards, Paul Online Developer, ICT CEO Sydney Winner of a National Australian Human Resources Institute Award and Australian Engineering Excellence Awards 2008 'Presidents Prize' ________________________________ Disclaimer: The information contained in this e-mail is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying, modification or disclosure is strictly prohibited. If you have received this e-mail in error please immediately advise us by return e-mail and delete the document without making a copy. No warranty is made that any attachments are free from viruses. It is the recipient's responsibility to establish its own protection against viruses and other damage. Winner of a National Australian Human Resources Institute Award and Australian Engineering Excellence Awards 2008 'Presidents Prize' ________________________________ Disclaimer: The information contained in this e-mail is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying, modification or disclosure is strictly prohibited. If you have received this e-mail in error please immediately advise us by return e-mail and delete the document without making a copy. No warranty is made that any attachments are free from viruses. It is the recipient's responsibility to establish its own protection against viruses and other damage.
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss