Hi, I'm not sure exactly what you mean, however the application is started in debug mode and the profiler is running when I do the query in Console.
Bill On Jun 9, 12:38 pm, michaelm <[email protected]> wrote: > Hi, > > In first case, you say JProfiler reports the time > In second case, the Console reports the time > > Is your profiler interacting the same way with your application in > both cases ? > > Michaël > > On 9 juin, 18:01, William Osmond <[email protected]> wrote: > > > > > Yes, exactly the same. > > > On Jun 8, 2:39 pm, Kerry Sainsbury <[email protected]> wrote: > > > > Are you using exactly the same JDBC connection URL? > > > > On Wed, Jun 9, 2010 at 6:43 AM, William Osmond > > > <[email protected]>wrote: > > > > > Hello Thomas+all, > > > > I'm experience a rather strange performance problem that I'm hoping > > > > you can provide some insight into. I have a query which takes many > > > > times longer to execute in my code than it does in the H2 console. > > > > Figuring it was probably something dumb I was doing after retrieving > > > > the data from the database which was causing the bad performance I ran > > > > it through a profiler, however that is telling me that the time really > > > > is spent in jdbc call. > > > > > JProfiler reports the following: > > > > 27,188 ms - 1 evt. select apinumber, well, operator, field, lease, > > > > longitude, latitude from wells where (longitude >= -118.553345 and > > > > longitude <= -117.705826 and latitude >= 33.670765 and latitude <= > > > > 34.140205) and status in ('008', '009') > > > > > and when I run it in H2 Console: > > > > (6051 rows, 584 ms) > > > > > explain select apinumber, well, operator, field, lease, longitude, > > > > latitude from wells where (longitude >= -118.553345 and longitude <= > > > > -117.705826 and latitude >= 33.670765 and latitude <= 34.140205) and > > > > status in ('008', '009'); > > > > PLAN > > > > SELECT APINUMBER, WELL, OPERATOR, FIELD, LEASE, LONGITUDE, LATITUDE > > > > FROM PUBLIC.WELLS /* PUBLIC.WELLS_LATINDEX: LATITUDE <= 34.140205 AND > > > > LATITUDE >= 33.670765 */ > > > > WHERE (STATUS IN('008', '009')) AND ((LATITUDE <= 34.140205) AND > > > > ((LATITUDE >= 33.670765) AND ((LONGITUDE >= -118.553345) AND > > > > (LONGITUDE <= -117.705826)))) > > > > > Any ideas would be greatly appreciated. > > > > > -Bill > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups > > > > "H2 Database" group. > > > > To post to this group, send email to [email protected]. > > > > To unsubscribe from this group, send email to > > > > [email protected]<h2-database%2bunsubscr...@googlegr > > > > oups.com> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/h2-database?hl=en. -- You received this message because you are subscribed to the Google Groups "H2 Database" 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/h2-database?hl=en.
