> The code is in an abstraction layer, so I have a method like
> fetchObjectsUsingCriteria(). This method call was taking something
> like 10,107ms. I was scratching my head about the 10 second delay, so
> I cracked that method open and put timings around the individual
> components of the fetch. This method ONLY does select statements,
> updates are handled elsewhere.
>
> An interesting side-note is that when I do updates or inserts they
> only take about 300ms. The 10 second lag only happens on reads, not
> writes.
>
> Thanks,
> - Dave
>

But what quantity of reading are you doing? Is it a large dataset?
Inserts, updates and deletes to single records are indeed fast.
Alan