Since it's the same method, Andrus is probably right, you are creating the
typed DataContext (the type of SchemaModel in your sample below) between
each call.Anyway 8s is a very poor performance. Usually I get something like
500ms on big requests.What is your configuration? Is there something else
running and eating all your CPU?
On Wed, Nov 19, 2008 at 16:56, Jimbo1982 <[EMAIL PROTECTED]> wrote:
>
> The linq expression is in a method of a class which has access to a
> single model of my database schema (I believe that is what you mean
> from DataContext).
>
> The method is called each time with a different input, which
> represents the element for the where clause of the select.
>
> Simplified method:
>
> public List<Slot> GetWarehouseSlotDetails(WarehouseStation
> warehouseStation)
> {
> var slots = from ps in SchemaModel.PickSlot
> where ps.StationID ==
> warehouseStation.Id.Value
> join s in SchemaModel.SkU on ps.SkUID
> equals s.SkUID into tmpProductSlot
> from subsku in
> tmpProductSlot.DefaultIfEmpty()
> select new
> {
> ps.PickSlotID,
> subsku.Description
> };
> }
>
> Thank you,
>
> James
> >
>
--
Pascal.
jabber/gtalk: [EMAIL PROTECTED]
msn: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
