by Rob 14 May 11:44
Top 10 Queries by Average execution time

For this website the 'live' information is at:

http://www.avaje.org/metatopqueries.html

14 May 11:45
by Rob

Code to get this information in Ebean v1.2

// code to get Top 10 queries by average execution time 

List<MetaQueryStatistic> list = Ebean.find(MetaQueryStatistic.class).findList();
  	
long nowMinus24Hrs = System.currentTimeMillis() -24*(1000*60*60);

list = Ebean.filter(MetaQueryStatistic.class)
		.sort("avgTimeMicros desc")
		.gt("executionCount", 0)
		.gt("lastQueryTime", nowMinus24Hrs)
		.maxRows(10)
		.filter(list);

Create a New Topic

Title:
Body:
 
Introduction User Guide (pdf) Install/Configure Public JavaDoc Whitepapers
General Database Specific Byte Code Deployment Annotations Features
Top Bugs Top Enhancements
woResponse