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.
