Generating timings of llblgen's operations

Posts   
 
    
wordracr
User
Posts: 12
Joined: 16-Sep-2009
# Posted on: 02-Nov-2009 18:18:04   

Hi - the reason I need to do this is because my organization is concerned about where the slowdown is (as compared to doing a stored procedure).

Is there a way I can hook into some 'events' or something in order to get the amount of time llblgen spends before it hits the db and after (Entity object population)?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 03-Nov-2009 05:35:10   

You could:

  1. Override OnFetchEntity. Call the base for that method. Take the time in some variable. (The time the query started).

  2. Overide OnFetchEntityComplete. Call the base for that method. Take the time in another variable (the time the query execute is done). Subtract and now you know how long took the query execution. At this point you can acces the IRetrievalQuery parameter.

  3. Now you have to log that. How you plan to do that (DB, text file, etc.)? Do it.

Do you want more power and less headaches? Try Huagati Profiler. Now it supports LLBLGen Pro. I tried it and looks pretty nice so far.

David Elizondo | LLBLGen Support Team
wordracr
User
Posts: 12
Joined: 16-Sep-2009
# Posted on: 03-Nov-2009 17:50:47   

Either of those routes seem perfect. Thank you so much!