eager

Ways to avoid eager spool operations on SQL Server

I have an ETL process that involves a stored procedure that makes heavy use of SELECT INTO statements (minimally logged and therefore faster as they generate less log traffic). Of the batch of work that takes place in one particular stored the stored procedure several of the most expensive operations are eager spools that appear to just...

How to Eager Load entire SQL table in LINQ?

Writing my first Linq application, and I'm trying to find the best way to do the following: I want to load the entire employees table at once to populate the cache (used for form autocomplete). I can do - var query = from employee in db.Employees select employee; foreach (Employee e in query) { ... } But since this is deferred...

Is it possible to eager load over two one-to-many relationships in NHibernate?

Given an object hierarchy such as the following: class Category { List<SubCategory> SubCategories; } class SubCategory { List<Product> Products; } class Product { } Is it possible to eager load the whole hierarchy using NHibernate? I would like to execute one query to load all categories with subcategories and products eager...

Linq for NHibernate and fetch mode of eager loading

Is there a way to set the fetchmode to eager for more than one object using linq for nhibernate. There seems to be an expand method which only allows me to set one object. However I need to set it for more than one object. Is this possible? Thanks ...

Why would NHibernate eager fetch not work when called after an update in the same session?

Could any one explain why this query works beautifully when it is called by itself to load and fully hydrate a 3 level object graph in one fell swoop, but then fail when called immediately after an update and commit has been done on one of those children within the same session. To be clear, the SQL join is correctly created in both scen...

When is lazy evaluation not useful?

Delay execution is almost always a boon. But then there are cases when it’s a problem and you resort to “fetch” (in Nhibernate) to eager fetch it. Do you know practical situations when lazy evaluation can bite you back…? ...

How do you programmatically turn off eager fetching with hibernate?

I have in my mapping an association to an eagerly loaded collection (lazy="false" fetch="subselect"). How can I turn that off programmatically with Hibernate when I do a query? Thanks ...

Grails GORM Domain class relationship

Grails 1.1.1 Goovy 1.5.7 In a relationship such this: Author 1 -- n Book n -- 1 Publisher Defined in Grails: class Author { String firstName String lastName static hasMany = [books: Book] static constraints = { books(nullable: true) } } class Book { String title Author author Publisher ...

eagerly evaluating boolean expressions in Python

Hi! Is there a way (using eval or whatever) to evaluate eagerly boolean expressions in python? Let's see this: >>> x = 3 >>> 5 < x < y False Yikes! That's very nice, because this will be false regardless of y's value. The thing is, y can be even undefined, and I'd like to get that exception. How can I get python to evaluate all expre...

How do I disable "eager" validation entirely using jquery validate ?

Is there a way to disable "eager" validation using the jquery.validate plugin? Either through an option in the script or as a hack? "Eager" validation kicks in once the form has been validated once - after that, invalid fields are validated onfocusout. I want to disable this behavior, and change my forms to only be validated when the s...

Hibernate: Overriding mapping's EAGER in HQL?

It's possible to override LAZY in HQL using LEFT JOIN FETCH. FROM Obj AS obj LEFT JOIN FETCH obj.otherObj WHERE obj.id = :id Is it also possible to override EAGER? How? ...

Entity Framework 4 POCO - Lazy + Eager Loading

I have the following DB structure (simplified version): Comments - CommentId, UserId Users - UserId UserDetails - UserId, Address, Phone, etc. I am using EF 4 with POCOs. The User property of the Comment class is marked as virtual (to enable lazy loading for it). However, I want when the User property is loaded (lazy) also its UserDet...

F# lazy eval from stream reader?

I'm running into a bug in my code that makes me think that I don't really understand some of the details about F# and lazy evaluation. I know that F# evaluates eagerly and therefore am somewhat perplexed by the following function: // Open a file, then read from it. Close the file. return the data. let getStringFromFile = File.Open...