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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
