Hi Noel,
Just extra information -
Tables
=======
CREATE TABLE CLIENTS (
CL_ID BIGINT NOT NULL,
CL_NAME VARCHAR(1024) DEFAULT '' NOT NULL,
CONSTRAINT CLIENTS_pk PRIMARY KEY (CL_ID)
);
CREATE INDEX CLIENTS_idx
ON CLIENTS
( CL_NAME ASC );
CREATE TABLE REQUESTS (
REQ_ID IDENTITY NOT NULL,
REQ_TYPE INTEGER NOT NULL,
REQ_DATE TIMESTAMP DEFAULT current_timestamp() NOT NULL,
CL_ID BIGINT NOT NULL,
CONSTRAINT REQUESTS_pk PRIMARY KEY (REQ_ID)
);
CREATE INDEX REQUESTS_TYPE_idx
ON REQUESTS
( REQ_TYPE ASC );
CREATE INDEX REQUESTS_DATE_idx
ON REQUESTS
( REQ_DATE ASC );
ALTER TABLE REQUESTS ADD CONSTRAINT CLIENTS_REQUESTS_fk
FOREIGN KEY (CL_ID)
REFERENCES CLIENTS (CL_ID)
To access database I use FRM Slick, that generates queries
for reading something like - select * from requests where req_date between
start_date and end_date.
for writing something like - insert into requests values
(default,tev,ts,clid)
In general I need another filter for reading query - on cl_id, so it would
be
select * from requests where req_date between start_date and end_date and
cl_id=clid,
but I found it takes 2 times longer to execute the query than the first
one. So, after getting a result
as List[Request] just use result.filter(r => r.cl_id == clid)
On Saturday, April 18, 2015 at 3:36:10 PM UTC+3, sim wrote:
>
> Hi Noel,
>
> Nothing special - jdbc:h2:tcp://192.168.1.10:9099/stats
>
> h2-1.4.187 with default MVStore
>
>
> On Saturday, April 18, 2015 at 12:48:14 PM UTC+3, Noel Grandin wrote:
>>
>> What does your db URL look like?
>> On Fri, 17 Apr 2015 at 20:32, sim <sim...@mail.ru> wrote:
>>
>>> Hi,
>>>
>>> Here is a logger output from my application:
>>>
>>> 2015-04-17 20:29:07,363 - [INFO] - from application in
>>> play-akka.actor.default-dispatcher-24
>>> start to get statistic data - 2015-04-17 20:29:07.363
>>>
>>> 2015-04-17 20:29:12,425 - [INFO] - from application in
>>> application-akka.actor.default-dispatcher-12
>>> Couldn't save statistic messages - Futures timed out after [5000
>>> milliseconds]
>>>
>>> 2015-04-17 20:29:17,027 - [INFO] - from application in
>>> play-akka.actor.default-dispatcher-24
>>> end to get statistic data - 2015-04-17 20:29:17.027
>>>
>>> 2015-04-17 20:29:17,027 - [INFO] - from application in
>>> play-akka.actor.default-dispatcher-24
>>> data records for 2015-04-17 - 197873
>>>
>>>
>>> A thread reads from a table statistics data - 197873 rows (it takes
>>> about 10 seconds)
>>> Inside this interval another thread is trying to write new data into the
>>> table with 5 seconds timeout
>>> and gets timeout.
>>>
>>> So my question - does MVSTORE really support concurrent read/write?
>>>
>>> Thank you
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "H2 Database" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to h2-database...@googlegroups.com.
>>> To post to this group, send email to h2-da...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/h2-database.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
