Hi Evgenii,
Thank you for suggesting the query optimization. It worked perfectly fine.
I unnecessarily complicated the sql.
I really appreciate the efforts you guys are taking to help out the users.
About the test data: Yes in production I will be having more than 100K
records for single subscrip
Well, looks like you trying to find the segments that intersects defined
segment, but you're complicating it. You don't need 3 conditions here - it
will be enough to have only one - ipStart <= MAX and ipEnd >= MIN. I've
checked it for your case and got absolutely the same results as you have
with a
Hi Evgenii,
Did you get time to check the reproducer?
Can you please suggest solution for this?
Thanks,
Prasad
On Fri, Oct 19, 2018, 4:46 PM Prasad Bhalerao
wrote:
> Hi Evgenii,
>
> I have created a reproducer and uploaded it to GitHub. I have created 5
> cases to test the sql execution tim
Hi Evgenii,
I have created a reproducer and uploaded it to GitHub. I have created 5
cases to test the sql execution time.
GitHub project: https://github.com/prasadbhalerao1983/IgniteTestPrj.git
Please run IgniteQueryTester class.
Thanks,
Prasad
On Wed, Oct 17, 2018 at 7:46 PM ezhuravlev wrote
How much data do you have? What is the amount of heap and offheap memory?
Can you share the reproducer with the community?
Evgenii
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi, Evgenii,
I tried to execute sql without UNION ALL operator. I mean I just executed
the first part of the sql as shown below and it is taking 700-800 ms to
complete. I have around 3 million records in my cache. and will be having
around 30-40 million records in real scenario.
SELECT id, module
Hi,
What is the execution time of just a single query without UNION?
Evgenii
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
an we have update on this?
>
> -- Forwarded message -
> From: Prasad Bhalerao
> Date: Wed, Sep 5, 2018, 11:34 AM
> Subject: Re: Query execution too long even after providing index
> To:
>
>
> Hi Andrey,
>
> Can you please help me
?
-- Forwarded message -
From: Prasad Bhalerao
Date: Wed, Sep 5, 2018, 11:34 AM
Subject: Re: Query execution too long even after providing index
To:
Hi Andrey,
Can you please help me with this? I
Thanks,
Prasad
On Tue, Sep 4, 2018 at 2:08 PM Prasad Bhalerao
wrote:
>
> I tried ch
Hi Andrey,
Can you please help me with this? I
Thanks,
Prasad
On Tue, Sep 4, 2018 at 2:08 PM Prasad Bhalerao
wrote:
>
> I tried changing SqlIndexMaxInlineSize to 32 byte and 100 byte using cache
> config.
>
> ipContainerIpV4CacheCfg.setSqlIndexMaxInlineSize(32/100);
>
> But it did not improve
I tried changing SqlIndexMaxInlineSize to 32 byte and 100 byte using cache
config.
ipContainerIpV4CacheCfg.setSqlIndexMaxInlineSize(32/100);
But it did not improve the sql execution time. Sql execution time increases
with increase in cache size.
It is a simple range scan query. Which part of the
HI,
Have you tried to increase index inlineSize? It is 10 bytes by default.
Your indices uses simple value types (Java primitives) and all columns can
be easily inlined.
It should be enough to increase inlineSize up to 32 bytes (3 longs + 1 int
= 3*(8 /*long*/ + 1/*type code*/) + (4/*int*/ + 1/*t
12 matches
Mail list logo