Do all those requests come from the same LINQ expression (same piece of code)?
On Wed, Nov 19, 2008 at 16:39, Jimbo1982 <[EMAIL PROTECTED]> wrote: > > This does not seem to be happening, > > Each time the Expression Build is taking ~8 seconds to complete. Below > are a few examples from one run of my application. > > Thank you for the quick response. > > James > > 2008-11-19 15:37:05Z Select Expression build: 6935ms > 2008-11-19 15:37:05Z Select SQL build: 3ms > 2008-11-19 15:37:05Z Select SQL: SELECT ps$.PICK_SLOT_ID, ps$.X_COORD, > ps$.Y_COORD, ps$.Z_COORD, ps$.MAX_WEIGHT, ps$.TU_TYPE, ps$.MACHINE_ID, > ps$.REPLEN_LOC_ID, ps$.OLD, ps$.SKU_ID, s$.EACH_VOLUME, s > $.EACH_WEIGHT, s$.BAG_SEGREGATION_DAMAGE, s$.BAG_SPACE, s > $.COMMONALITY, s$.WINE_HOLDER, s$.DESCRIPTION, s$.EACH_HEIGHT, s > $.EACH_WIDTH, s$.EACH_LENGTH, s$.SAMPLE > FROM WMSADH.PICK_SLOT ps$ > LEFT JOIN WMSADH.SKU s$ ON ps$.SKU_ID = s$.SKU_ID > WHERE ps$.STATION_ID = :Value > > Select Expression build: 7474ms > Select SQL build: 0ms > Select SQL: SELECT ps$.PICK_SLOT_ID, ps$.X_COORD, ps$.Y_COORD, ps > $.Z_COORD, ps$.MAX_WEIGHT, ps$.TU_TYPE, ps$.MACHINE_ID, ps > $.REPLEN_LOC_ID, ps$.OLD, ps$.SKU_ID, s$.EACH_VOLUME, s$.EACH_WEIGHT, s > $.BAG_SEGREGATION_DAMAGE, s$.BAG_SPACE, s$.COMMONALITY, s > $.WINE_HOLDER, s$.DESCRIPTION, s$.EACH_HEIGHT, s$.EACH_WIDTH, s > $.EACH_LENGTH, s$.SAMPLE > FROM WMSADH.PICK_SLOT ps$ > LEFT JOIN WMSADH.SKU s$ ON ps$.SKU_ID = s$.SKU_ID > WHERE ps$.STATION_ID = :Value > > Select Expression build: 7557ms > Select SQL build: 0ms > Select SQL: SELECT ps$.PICK_SLOT_ID, ps$.X_COORD, ps$.Y_COORD, ps > $.Z_COORD, ps$.MAX_WEIGHT, ps$.TU_TYPE, ps$.MACHINE_ID, ps > $.REPLEN_LOC_ID, ps$.OLD, ps$.SKU_ID, s$.EACH_VOLUME, s$.EACH_WEIGHT, s > $.BAG_SEGREGATION_DAMAGE, s$.BAG_SPACE, s$.COMMONALITY, s > $.WINE_HOLDER, s$.DESCRIPTION, s$.EACH_HEIGHT, s$.EACH_WIDTH, s > $.EACH_LENGTH, s$.SAMPLE > FROM WMSADH.PICK_SLOT ps$ > LEFT JOIN WMSADH.SKU s$ ON ps$.SKU_ID = s$.SKU_ID > WHERE ps$.STATION_ID = :Value > > 2008-11-19 15:37:29Z Select Expression build: 7741ms > 2008-11-19 15:37:29Z Select SQL build: 0ms > 2008-11-19 15:37:29Z Select SQL: SELECT ps$.PICK_SLOT_ID, ps$.X_COORD, > ps$.Y_COORD, ps$.Z_COORD, ps$.MAX_WEIGHT, ps$.TU_TYPE, ps$.MACHINE_ID, > ps$.REPLEN_LOC_ID, ps$.OLD, ps$.SKU_ID, s$.EACH_VOLUME, s > $.EACH_WEIGHT, s$.BAG_SEGREGATION_DAMAGE, s$.BAG_SPACE, s > $.COMMONALITY, s$.WINE_HOLDER, s$.DESCRIPTION, s$.EACH_HEIGHT, s > $.EACH_WIDTH, s$.EACH_LENGTH, s$.SAMPLE > FROM WMSADH.PICK_SLOT ps$ > LEFT JOIN WMSADH.SKU s$ ON ps$.SKU_ID = s$.SKU_ID > WHERE ps$.STATION_ID = :Value > > > -- 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 -~----------~----~----~----~------~----~------~--~---
