I am afraid I don't think I have any improvment even for simpler SQL it is very slow on each expression build.
I also have lots and lots of exceptions, I am not sure if you get these and they are expected. If you need any more from the logs just let me know or if you want to make and specific logging changes to the code and then run my application I can do that also. Appreciate any more help you can offer. Cheers, James A first chance exception of type 'System.ArgumentException' occurred in DbLinq.dll A first chance exception of type 'System.InvalidOperationException' occurred in System.Core.dll Select Expression build: 1482ms Select SQL build: 0ms SELECT DELIVERY_DATE, FORECAST_DATE, FORECAST_EACHES, ORDERED_EACHES, SKU_ID FROM WMSADH.SKU_DEMAND_BY_DAY WHERE SKU_ID = :Value Select Expression build: 1596ms Select SQL build: 0ms SELECT DELIVERY_DATE, FORECAST_DATE, FORECAST_EACHES, ORDERED_EACHES, SKU_ID FROM WMSADH.SKU_DEMAND_BY_DAY WHERE SKU_ID = :Value Select Expression build: 4029ms Select SQL build: 0ms SELECT DELIVERY_DATE, FORECAST_DATE, FORECAST_EACHES, ORDERED_EACHES, SKU_ID FROM WMSADH.SKU_DEMAND_BY_DAY WHERE SKU_ID = :Value -- :Value: Input AnsiString (Size = 8; Prec = 0; Scale = 0) [12615011] And even longer for the more complicated SQL: Select Expression build: 6943ms Select SQL build: 0ms 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, ps$.WIDTH, 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: 7419ms Select SQL build: 0ms 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, ps$.WIDTH, 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: 7454ms Select SQL build: 0ms 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, ps$.WIDTH, 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 -- :Value: Input AnsiString (Size = 5; Prec = 0; Scale = 0) [Z1B05] -- Context: Oracle Model: AttributedMetaModel Build: 0.19.0.0 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
