Thanks for help Thomas. Well after many other tests I got to the point that in case of many invocations on production environment the average query time is 0,15 second to 0,20 second. So even if a few times it is long, other ones are fast. Of course it would be nice to have it faster anyway (I don't know if it is slow - 0,15sec) but now I feel I have to focus on redesigning code in the way that it would not query so many times.
The result is only one row (SELECT LIMIT), I also indexed DATA field but it did not change much. Ok - I have Java runtime, embeded version on files, maybe some background processes in IDE so, for now let's stop investigations ;) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
