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.
