Yes, we want the logs! Anything that help, in fact ;)Regarding the cache, at least does it work now?
On Mon, Nov 24, 2008 at 18:15, Jimbo1982 <[EMAIL PROTECTED]> wrote: > > 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 > > > -- 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 -~----------~----~----~----~------~----~------~--~---
