Hi,
Challenging the possibilty that the latancy is related with the number of
record is a good guess indeed. It might be, but I don't think so, given the
max 50 Mb partition size. This should should allow to catch a partition of
this size, probably below 1 second.
It is possible to trace a query
The size is less than 50MB
Sent using Zoho Mail
On Sat, 07 Apr 2018 09:09:41 +0430 Laxmikant Upadhyay
wrote
It seems your partition size is more..what is the size of value field ? Try to
keep your partition size within 100 mb.
On Sat, Apr 7, 2018
It seems your partition size is more..what is the size of value field ? Try
to keep your partition size within 100 mb.
On Sat, Apr 7, 2018, 9:45 AM onmstester onmstester
wrote:
>
> I've defained a table like this
>
> create table test (
> hours int,
> key1 int,
> value1 varchar,
> primary key (h
I've defained a table like this
create table test (
hours int,
key1 int,
value1 varchar,
primary key (hours,key1)
)
For one hour every input would be written in single partition, because i need
to group by some 500K records in the partition for a report with expected
response time in