|
Hi,
I'm trying to pre-fetch some foreign key data using a linq query. A quick example to explain my problem follows:
var results = (from c in _customers from ct in _customerTypes where c.TypeId == ct.TypeId select new Customer { CustomerId = c.CustomerId...
Started by Dominic Godin on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at stackoverflow):
You can get everything from the Customer class by doing it like this:
var results = (from c ... .
The (arguably) easiest thing to do would be to create a new class that encapsulates the properties you need .
As it says, you can't construct a Customer there.
|
|
On Sun, 12 Apr 2009 18:23:39 -0500, JD <JD@example.invalid
How does one disable prefetch?
--
JD..
Started by JD on
, 30 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Mikeyhsd@lamparty.net
"JD" ....
BE VERY CAREFUL.
When you find the "3" places change each to "0" .
Search for Prefetch.
For a program called
windows-xp-prefetch-clean-and-control.exe
for Vista and/or W7, it requires a REGISTRY edit.
|
|
On Fri, 10 Apr 2009 12:06:13 -0700, "Dallas" <Jagged Edge@StillIStruggle
hello all,
in googling around for answers to my hotmail issue - see post below - i
landed at a forum & came across some questions on prefetch file; the answers
were to ...
Started by Dallas on
, 14 posts
by 6 people.
Answer Snippets (Read the full thread at omgili):
On Fri, 10 Apr 2009 18:11:06 -0500, "mikeyhsd" <mikeyhsd@hotmail.com
personally I always run with PREFETCH....
Programs will start to run a little slower until
it rebuilds the prefetch it can prefetch.
Won't hurt anything.
|
Ask your Facebook Friends
|
On Fri, 1 May 2009 12:01:01 -0700, דודי <@discussions.microsoft.com
האם בניקוי המחשב מקבצים זמניים כדאי
למחוק גם את תכולת הספריה Prefetch ?
תודה
Started by דודי on
, 10 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Ask-leo.com/what_is_the_prefetch_folder_and_why_are_there_copies_of_system_files_there.html
דייב/dgbrowser/default.mspx?query=Prefetch&dg=microsoft.public.il.hebrew.windowsmedia&cat=&lang=he&cr=IL&pt.
|
|
On Sat, 2 May 2009 04:40:01 -0700, ניסו רושה <@discussions.microsoft.com
אם אכן נכונים דבריו של האיש עם הסמל הצהוב שיואיל להגיב לאחר שיגמור לקרוא את
כל הכתוב שמופיע פה
http://www.fux-c.co.il/showthread.php?t=32315
--
באם תשובתי זו סייעה לפתרון...
Started by ניסו רושה on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Communities/newsgroups/dgbrowser/default.mspx?query=Prefetch&dg=microsoft.public.il.hebrew.windowsmedia.
|
|
I have contacts that can be in more than one group and have more than one request. I need to simply get contacts for a specific group that have no specific requests.
How do I improve the performance of this query:
SELECT top 1 con_name , con_id FROM tbl...
Answer Snippets (Read the full thread at stackoverflow):
What is the request_id.
This usually has better performance than a sub-query.
Your query is ok, just create the following indexes:
tbl_request_to_contact (request_id, con_id don't have requests.
|
|
I need help with NHibernate. I'm using 2.1, but have tried this on 3 as well, with same results. Any help most appreciated!
When doing an ICriteria query using NHibernate, it executes both the query, and then for each result in the query, it executes ...
Started by Gavin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
From Client c left join fetch bizarrely, after trying various changes to the query, from hql to icriteria formats, nothing worked.
On lazy loading and then use HQL queries to prefetch required children.
|
|
I upgraded from sql server 2000 to 2008 over the weekend. Now one query is running really slow (> 30sec for about 50 rows).
The query is:
SELECT TOP 200 AccData.SurName + ', ' + AccData.FirstNames AS Name, DATEDIFF(day, COALESCE (AccData.DateReceived...
Started by SeanX on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Though I do note a few minor issues I'll....
Have you tried using the missing index feature in SQL 2008 .
Is the query only slow the first time, or every time in a different (and slower) query plan.
It sometimes includes index suggestions.
|
|
Hello,
This question is linked to my previous one ( posted as an anonymous user - now I have an account ) and, before I begin, I would like to give the credit to Rob Farley for providing the right indexing schema.
But the problem is not the indexing schema...
Started by Adrian S. on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Is there a reason you can't use index hints (as in your second query) when you're using the variable (in the third query)? It's odd that the query optimizer makes such a bad decision when the indexes themselves are only built on top....
|
|
A query runs fast:
DECLARE @SessionGUID uniqueidentifier SET @SessionGUID = 'BCBA333C-B6A1-4155-9833-C495F22EA908' SELECT * FROM Report_Opener WHERE SessionGUID = @SessionGUID ORDER BY CurrencyTypeOrder, Rank
subtree cost: 0.502
But putting the same SQL...
Started by Ian Boyd on
, 10 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
SECOND titled "Table Hints" that's what you....
You tried providing any query hints on the SP version of the query? If SQL Server is preparing query plan here, perhaps we can identify some difference between the plans that's telling.
|
