Are you using exactly the same JDBC connection URL?
On Wed, Jun 9, 2010 at 6:43 AM, William Osmond <william.osm...@gmail.com>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 h2-datab...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com<h2-database%2bunsubscr...@googlegroups.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 h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
